SqlServerGrammar
class SqlServerGrammar extends Grammar (View source)
Properties
| protected string | $tablePrefix | The grammar table prefix. |
from Grammar |
| protected array | $operators | All of the available clause operators. |
|
| protected array | $selectComponents | The components that make up a select clause. |
from Grammar |
Methods
Wrap a value that has an alias.
Wrap a single string in keyword identifiers.
Convert an array of column names into a delimited string.
Get the appropriate query parameter place-holder for a value.
Get the format for database stored dates.
Format the where clause statements into one string.
Compile the random statement into SQL.
Compile an insert and get ID statement into SQL.
Prepare the bindings for an update statement.
Prepare the bindings for a delete statement.
Determine if the grammar supports savepoints.
Compile the SQL statement to define a savepoint.
Compile the SQL statement to execute a savepoint rollback.
Concatenate an array of segments, removing empties.
Remove the leading boolean from a statement.
Create a full ANSI offset clause for the query.
Compile the over statement for a table expression.
Compile a delete statement with joins into SQL.
Get the table and alias for the given table.
Wrap a table in keyword identifiers.
Details
array
wrapArray(array $values)
Wrap an array of values.
string
wrapTable(Expression|string $table)
Wrap a table in keyword identifiers.
string
wrap(Expression|string $value, bool $prefixAlias = false)
Wrap a value in keyword identifiers.
protected string
wrapAliasedValue(string $value, bool $prefixAlias = false)
Wrap a value that has an alias.
protected string
wrapSegments(array $segments)
Wrap the given value segments.
protected string
wrapValue(string $value)
Wrap a single string in keyword identifiers.
string
columnize(array $columns)
Convert an array of column names into a delimited string.
string
parameterize(array $values)
Create query parameter place-holders for an array.
string
parameter(mixed $value)
Get the appropriate query parameter place-holder for a value.
bool
isExpression(mixed $value)
Determine if the given value is a raw expression.
string
getValue(Expression $expression)
Get the value of a raw expression.
string
getDateFormat()
Get the format for database stored dates.
string
getTablePrefix()
Get the grammar's table prefix.
$this
setTablePrefix(string $prefix)
Set the grammar's table prefix.
string
compileSelect(Builder $query)
Compile a select query into SQL.
protected array
compileComponents(Builder $query)
Compile the components necessary for a select clause.
protected string
compileAggregate(Builder $query, array $aggregate)
Compile an aggregated select clause.
protected string|null
compileColumns(Builder $query, array $columns)
Compile the "select *" portion of the query.
protected string
compileFrom(Builder $query, string $table)
Compile the "from" portion of the query.
protected string
compileJoins(Builder $query, array $joins)
Compile the "join" portions of the query.
protected string
compileWheres(Builder $query)
Compile the "where" portions of the query.
protected array
compileWheresToArray(Builder $query)
Get an array of all the where clauses for the query.
protected string
concatenateWhereClauses(Builder $query, array $sql)
Format the where clause statements into one string.
protected string
whereRaw(Builder $query, array $where)
Compile a raw where clause.
protected string
whereBasic(Builder $query, array $where)
Compile a basic where clause.
protected string
whereIn(Builder $query, array $where)
Compile a "where in" clause.
protected string
whereNotIn(Builder $query, array $where)
Compile a "where not in" clause.
protected string
whereInSub(Builder $query, array $where)
Compile a where in sub-select clause.
protected string
whereNotInSub(Builder $query, array $where)
Compile a where not in sub-select clause.
protected string
whereNull(Builder $query, array $where)
Compile a "where null" clause.
protected string
whereNotNull(Builder $query, array $where)
Compile a "where not null" clause.
protected string
whereBetween(Builder $query, array $where)
Compile a "between" where clause.
protected string
whereDate(Builder $query, array $where)
Compile a "where date" clause.
protected string
whereTime(Builder $query, array $where)
Compile a "where time" clause.
protected string
whereDay(Builder $query, array $where)
Compile a "where day" clause.
protected string
whereMonth(Builder $query, array $where)
Compile a "where month" clause.
protected string
whereYear(Builder $query, array $where)
Compile a "where year" clause.
protected string
dateBasedWhere(string $type, Builder $query, array $where)
Compile a date based where clause.
protected string
whereColumn(Builder $query, array $where)
Compile a where clause comparing two columns.
.
protected string
whereNested(Builder $query, array $where)
Compile a nested where clause.
protected string
whereSub(Builder $query, array $where)
Compile a where condition with a sub-select.
protected string
whereExists(Builder $query, array $where)
Compile a where exists clause.
protected string
whereNotExists(Builder $query, array $where)
Compile a where exists clause.
protected string
compileGroups(Builder $query, array $groups)
Compile the "group by" portions of the query.
protected string
compileHavings(Builder $query, array $havings)
Compile the "having" portions of the query.
protected string
compileHaving(array $having)
Compile a single having clause.
protected string
compileBasicHaving(array $having)
Compile a basic having clause.
protected string
compileOrders(Builder $query, array $orders)
Compile the "order by" portions of the query.
protected array
compileOrdersToArray(Builder $query, array $orders)
Compile the query orders to an array.
string
compileRandom(string $seed)
Compile the random statement into SQL.
protected string
compileLimit(Builder $query, int $limit)
Compile the "limit" portions of the query.
protected string
compileOffset(Builder $query, int $offset)
Compile the "offset" portions of the query.
protected string
compileUnions(Builder $query)
Compile the "union" queries attached to the main query.
protected string
compileUnion(array $union)
Compile a single union statement.
string
compileExists(Builder $query)
Compile an exists statement into SQL.
string
compileInsert(Builder $query, array $values)
Compile an insert statement into SQL.
string
compileInsertGetId(Builder $query, array $values, string $sequence)
Compile an insert and get ID statement into SQL.
string
compileUpdate(Builder $query, array $values)
Compile an update statement into SQL.
array
prepareBindingsForUpdate(array $bindings, array $values)
Prepare the bindings for an update statement.
string
compileDelete(Builder $query)
Compile a delete statement into SQL.
array
prepareBindingsForDelete(array $bindings)
Prepare the bindings for a delete statement.
array
compileTruncate(Builder $query)
Compile a truncate table statement into SQL.
protected string
compileLock(Builder $query, bool|string $value)
Compile the lock into SQL.
bool
supportsSavepoints()
Determine if the grammar supports savepoints.
string
compileSavepoint(string $name)
Compile the SQL statement to define a savepoint.
string
compileSavepointRollBack(string $name)
Compile the SQL statement to execute a savepoint rollback.
protected string
concatenate(array $segments)
Concatenate an array of segments, removing empties.
protected string
removeLeadingBoolean(string $value)
Remove the leading boolean from a statement.
array
getOperators()
Get the grammar specific operators.
protected string
compileAnsiOffset(Builder $query, array $components)
Create a full ANSI offset clause for the query.
protected string
compileOver(string $orderings)
Compile the over statement for a table expression.
protected string
compileTableExpression(string $sql, Builder $query)
Compile a common table expression for a query.
protected string
compileRowConstraint(Builder $query)
Compile the limit / offset row constraint for a query.
protected string
compileDeleteWithJoins(Builder $query, string $table, string $where)
Compile a delete statement with joins into SQL.
protected array
parseUpdateTable(string $table)
Get the table and alias for the given table.
protected string
wrapTableValuedFunction(string $table)
Wrap a table in keyword identifiers.