$select public property The columns being selected. For example, ['id', 'name']. This is used to construct the SELECT clause in a SQL statement. If not set, it means selecting all columns. See also select(). public array $select = null

$params public property List of query parameter values indexed by parameter placeholders. For example, [':name' => 'Dan', ':age' => 31]. public array $params = []

$join public property How to join with other tables. Each array element represents the specification of one join which has the following structure: [$joinType, $tableName, $joinCondition] For example, [ ['INNER JOIN', 'user', 'user.id = author_id'], ['LEFT JOIN', 'team', 'team.id = team_id'], ] public array $join = null

$having public property The condition to be applied in the GROUP BY clause. It can be either a string or an array. Please refer to where() on how to specify the condition. public string|array|yii\db\Expression $having = null

$groupBy public property How to group the query results. For example, ['company', 'department']. This is used to construct the GROUP BY clause in a SQL statement. public array $groupBy = null

$from public property The table(s) to be selected from. For example, ['user', 'post']. This is used to construct the FROM clause in a SQL statement. See also from(). public array $from = null

$distinct public property Whether to select distinct rows of data only. If this is set true, the SELECT clause would be changed to SELECT DISTINCT. public boolean $distinct = null

resolveTableNames() protected method Resolves the table name and schema name (if any). protected void resolveTableNames ( $table, $name )$table yii\db\TableSchema The table metadata object $name string The table name

quoteSimpleTableName() public method Quotes a table name for use in a query. A simple table name has no schema prefix. public string quoteSimpleTableName ( $name )$name string Table name return string The properly quoted table name

loadTableSchema() public method Loads the metadata for the specified table. public yii\db\TableSchema|null loadTableSchema ( $name )$name string Table name return yii\db\TableSchema|null Driver dependent table metadata. Null if the table does not exist.