buildHashCondition() public method Creates a condition based on column-value pairs. public string buildHashCondition ( $condition, &$params )$condition array The condition specification. $params array The binding parameters to be populated return string The generated SQL expression

buildGroupBy() public method public string buildGroupBy ( $columns, &$params )$columns array $params array The binding parameters to be populated return string The GROUP BY clause

buildFrom() public method public string buildFrom ( $tables, &$params )$tables array $params array The binding parameters to be populated return string The FROM clause built from yii\db\Query::$from.

buildExistsCondition() public method Creates an SQL expressions with the EXISTS operator. public string buildExistsCondition ( $operator, $operands, &$params )$operator string The operator to use (e.g. EXISTS or NOT EXISTS) $operands array Contains only one element which is a yii\db\Query object representing the sub-query. $params array The binding parameters to be populated return string The generated SQL expression throws yii\base\InvalidParamException if the operand is not

buildCondition() public method Parses the condition specification and generates the corresponding SQL expression. public string buildCondition ( $condition, &$params )$condition string|array|yii\db\Expression The condition specification. Please refer to yii\db\Query::where() on how to specify a condition. $params array The binding parameters to be populated return string The generated SQL expression

buildCompositeInCondition() protected method Builds SQL for IN condition protected string buildCompositeInCondition ( $operator, $columns, $values, &$params )$operator string $columns array|Traversable $values array $params array return string SQL

buildColumns() public method Processes columns and properly quotes them if necessary. It will join all columns into a string with comma as separators. public string buildColumns ( $columns )$columns string|array The columns to be processed return string The processing result

buildBetweenCondition() public method Creates an SQL expressions with the BETWEEN operator. public string buildBetweenCondition ( $operator, $operands, &$params )$operator string The operator to use (e.g. BETWEEN or NOT BETWEEN) $operands array The first operand is the column name. The second and third operands describe the interval that column value should be in. $params array The binding parameters to be populated return string The generated SQL expression throws yii\base\In

buildAndCondition() public method Connects two or more SQL expressions with the AND or OR operator. public string buildAndCondition ( $operator, $operands, &$params )$operator string The operator to use for connecting the given operands $operands array The SQL expressions to connect. $params array The binding parameters to be populated return string The generated SQL expression

build() public method Generates a SELECT SQL statement from a yii\db\Query object. public array build ( $query, $params = [] )$query yii\db\Query The yii\db\Query object from which the SQL statement will be generated. $params array The parameters to be bound to the generated SQL statement. These parameters will be included in the result with the additional parameters generated during the query building process. return array The generated SQL statement (the first array element) and th