SqlServerGrammar

# compileSelect ( Builder $query ) : string

Compile a select query into SQL.

Parameters

• $query Builder

# compileColumns ( Builder $query , $columns ) : string|null

Compile the "select *" portion of the query.

Parameters

• $query Builder
• $columns array

# compileFrom ( Builder $query , $table ) : string

Compile the "from" portion of the query.

Parameters

• $query Builder
• $table string

# whereBitwise ( Builder $query , $where ) : string

{@inheritdoc}

Parameters

• $query Builder
• $where array

# whereDate ( Builder $query , $where ) : string

Compile a "where date" clause.

Parameters

• $query Builder
• $where array

# whereTime ( Builder $query , $where ) : string

Compile a "where time" clause.

Parameters

• $query Builder
• $where array

# compileJsonContains ( $column , $value ) : string

Compile a "JSON contains" statement into SQL.

Parameters

• $column string
• $value string

# prepareBindingForJsonContains ( $binding ) : string

Prepare the binding for a "JSON contains" statement.

Parameters

• $binding mixed

# compileJsonLength ( $column , $operator , $value ) : string

Compile a "JSON length" statement into SQL.

Parameters

• $column string
• $operator string
• $value string

# compileHaving ( array $having ) : string

{@inheritdoc}

Parameters

• $having array

# compileHavingBitwise ( $having ) : string

Compile a having clause involving a bitwise operator.

Parameters

• $having array

# compileAnsiOffset ( Builder $query , $components ) : string

Create a full ANSI offset clause for the query.

Parameters

• $query Builder
• $components array

# compileOver ( $orderings ) : string

Compile the over statement for a table expression.

Parameters

• $orderings string

# queryOrderContainsSubquery ( $query ) : bool

Determine if the query's order by clauses contain a subquery.

Parameters

• $query Builder

# sortBindingsForSubqueryOrderBy ( $query ) : array

Move the order bindings to be after the "select" statement to account for an order by subquery.

Parameters

• $query Builder

# compileTableExpression ( $sql , $query ) : string

Compile a common table expression for a query.

Parameters

• $sql string
• $query Builder

# compileRowConstraint ( $query ) : string

Compile the limit / offset row constraint for a query.

Parameters

• $query Builder

# compileDeleteWithoutJoins ( Builder $query , $table , $where ) : string

Compile a delete statement without joins into SQL.

Parameters

• $query Builder
• $table string
• $where string

# compileRandom ( $seed ) : string

Compile the random statement into SQL.

Parameters

• $seed string

# compileLimit ( Builder $query , $limit ) : string

Compile the "limit" portions of the query.

Parameters

• $query Builder
• $limit int

# compileOffset ( Builder $query , $offset ) : string

Compile the "offset" portions of the query.

Parameters

• $query Builder
• $offset int

# compileLock ( Builder $query , $value ) : string

Compile the lock into SQL.

Parameters

• $query Builder
• $value bool|string

# wrapUnion ( $sql ) : string

Wrap a union subquery in parentheses.

Parameters

• $sql string

# compileExists ( Builder $query ) : string

Compile an exists statement into SQL.

Parameters

• $query Builder

# compileUpdateWithJoins ( Builder $query , $table , $columns , $where ) : string

Compile an update statement with joins into SQL.

Parameters

• $query Builder
• $table string
• $columns string
• $where string

# compileUpsert ( Builder $query , array $values , array $uniqueBy , array $update ) : string

Compile an "upsert" statement into SQL.

Parameters

• $query Builder
• $values array
• $uniqueBy array
• $update array

# prepareBindingsForUpdate ( array $bindings , array $values ) : array

Prepare the bindings for an update statement.

Parameters

• $bindings array
• $values array

# compileSavepoint ( $name ) : string

Compile the SQL statement to define a savepoint.

Parameters

• $name string

# compileSavepointRollBack ( $name ) : string

Compile the SQL statement to execute a savepoint rollback.

Parameters

• $name string

# getDateFormat ( ) : string

Get the format for database stored dates.

# wrapValue ( $value ) : string

Wrap a single string in keyword identifiers.

Parameters

• $value string

# wrapJsonSelector ( $value ) : string

Wrap the given JSON selector.

Parameters

• $value string

# wrapJsonBooleanValue ( $value ) : string

Wrap the given JSON boolean value.

Parameters

• $value string

# wrapTable ( $table ) : string

Wrap a table in keyword identifiers.

Parameters

• $table Expression |string

# wrapTableValuedFunction ( $table ) : string

Wrap a table in keyword identifiers.

Parameters

• $table string