SQLServer
class SQLServer extends Compiler
Compiles SQL Server queries.
Traits
Constants
JSON_PATH_SEPARATOR |
JSON path separator. |
Properties
static protected | $dateFormat | {@inheritdoc} | |
protected Query | $query | Query builder. | from Compiler |
protected array | $params | Query parameters. | from Compiler |
Methods
Compiles subquery, merges parameters and returns subquery SQL.
Returns an escaped identifier.
Builds a JSON value getter.
Builds a JSON value setter.
Returns a comma-separated list of compiled columns.
Compiles common table expressions.
Returns raw SQL or a paramter placeholder.
Returns a comma-separated list of parameters.
Returns a comma-separated list of parameter placeholders.
Compiles the FROM clause.
Compiles date comparison clauses.
Compiles date range clauses.
Compiles ORDER BY clauses.
Compiles LIMIT clauses.
Compiles OFFSET clauses.
Details
in Compiler at line 80
static string
setDateFormat(string $dateFormat)
Sets the date format.
in Compiler at line 90
static string
getDateFormat()
Gets the date format.
in Compiler at line 120
protected string
subquery(Subquery $subquery, bool $enclose = true)
Compiles subquery, merges parameters and returns subquery SQL.
at line 31
string
escapeIdentifier(string $identifier)
Returns an escaped identifier.
in Compiler at line 167
string
escapeIdentifiers(array $identifiers)
Returns an array of escaped identifiers.
in Compiler at line 183
protected bool
hasJsonPath(string $string)
Does the string have a JSON path?
at line 39
protected string
buildJsonGet(string $column, array $segments)
Builds a JSON value getter.
at line 47
protected string
buildJsonSet(string $column, array $segments, string $param)
Builds a JSON value setter.
in Compiler at line 221
string
escapeTableName(string $table)
Escapes a table name.
in Compiler at line 239
string
table(mixed $table)
Compiles a table.
in Compiler at line 265
string
escapeColumnName(string $column)
Escapes a column name.
in Compiler at line 290
string
columnName(string $column)
Compiles a column name.
in Compiler at line 310
string
columnNames(array $columns)
Returns a comma-separated list of column names.
in Compiler at line 329
string
column(mixed $column, bool $allowAlias = false)
Compiles a column.
in Compiler at line 356
string
columns(array $columns, bool $allowAlias = false)
Returns a comma-separated list of compiled columns.
in Compiler at line 374
protected string
commonTableExpressions(array $commonTableExpressions)
Compiles common table expressions.
in Compiler at line 406
protected string
setOperations(array $setOperations)
Compiles set operations.
in Compiler at line 430
protected string
param(mixed $param, bool $enclose = true)
Returns raw SQL or a paramter placeholder.
in Compiler at line 459
protected string
params(array $params, bool $enclose = true)
Returns a comma-separated list of parameters.
in Compiler at line 477
protected string
simpleParam(mixed $param)
Returns a parameter placeholder.
in Compiler at line 490
protected string
simpleParams(array $params)
Returns a comma-separated list of parameter placeholders.
at line 55
string
from($from)
Compiles the FROM clause.
in Compiler at line 519
protected string
where(array $where)
Compiles WHERE conditions.
in Compiler at line 539
protected string
whereRaw(array $where)
Compiles a raw WHERE condition.
at line 78
protected string
whereDate(array $where)
Compiles date comparison clauses.
in Compiler at line 562
protected string
whereColumn(array $where)
Compiles column comparison clauses.
in Compiler at line 582
protected string
between(array $where)
Compiles BETWEEN clauses.
at line 70
protected string
betweenDate(array $where)
Compiles date range clauses.
in Compiler at line 605
protected string
in(array $where)
Compiles IN clauses.
in Compiler at line 618
protected string
null(array $where)
Compiles IS NULL clauses.
in Compiler at line 629
protected string
exists(array $where)
Compiles EXISTS clauses.
in Compiler at line 640
protected string
nestedWhere(array $where)
Compiles nested WHERE conditions.
in Compiler at line 651
protected string
whereConditions(array $wheres)
Compiles WHERE conditions.
in Compiler at line 673
protected string
wheres(array $wheres)
Compiles WHERE clauses.
in Compiler at line 689
protected string
joinCondition(array $condition)
Compiles a JOIN condition.
in Compiler at line 700
protected string
nestedJoinCondition(array $condition)
Compiles nested JOIN condition.
in Compiler at line 735
protected string
joins(array $joins)
Compiles JOIN clauses.
in Compiler at line 758
protected string
groupings(array $groupings)
Compiles GROUP BY clauses.
at line 86
protected string
orderings(array $orderings)
Compiles ORDER BY clauses.
in Compiler at line 792
protected string
havingCondictions(array $havings)
Compiles HAVING conditions.
in Compiler at line 814
protected string
havings(array $havings)
Compiles HAVING clauses.
at line 99
protected string
limit(int|null $limit)
Compiles LIMIT clauses.
at line 112
protected string
offset(int|null $offset)
Compiles OFFSET clauses.
in Compiler at line 852
protected string
lock(bool|string|null $lock)
Compiles locking clause.
in Compiler at line 862
array
select()
Compiles a SELECT query.
in Compiler at line 888
protected string
insertWithValues(array $values)
Returns a INSERT query with values.
in Compiler at line 903
protected string
insertWithoutValues()
Returns a INSERT query without values.
in Compiler at line 914
array
insert(array $values = [])
Compiles a INSERT query.
in Compiler at line 936
protected string
updateColumns(array $columns)
Compiles update columns.
in Compiler at line 967
array
update(array $values)
Compiles a UPDATE query.
in Compiler at line 984
array
delete()
Compiles a DELETE query.
in JsonPathBuilderTrait at line 26
protected string
buildJsonPath(array $segments)
Builds a JSON path.