Documentation

SqlServerGrammar extends Grammar

in package

• Application

Table of Contents

$operators  : array<string|int, mixed>

All of the available clause operators.

$selectComponents  : array<string|int, mixed>

The components that make up a select clause.

$tablePrefix  : string

The grammar table prefix.

columnize()  : string

Convert an array of column names into a delimited string.

compileDelete()  : string

Compile a delete statement into SQL.

compileExists()  : string

Compile an exists statement into SQL.

compileInsert()  : string

Compile an insert statement into SQL.

compileInsertGetId()  : string

Compile an insert and get ID statement into SQL.

compileRandom()  : string

Compile the random statement into SQL.

compileSavepoint()  : string

Compile the SQL statement to define a savepoint.

compileSavepointRollBack()  : string

Compile the SQL statement to execute a savepoint rollback.

compileSelect()  : string

Compile a select query into SQL.

compileTruncate()  : array<string|int, mixed>

Compile a truncate table statement into SQL.

compileUpdate()  : string

Compile an update statement into SQL.

getDateFormat()  : string

Get the format for database stored dates.

getOperators()  : array<string|int, mixed>

Get the grammar specific operators.

getTablePrefix()  : string

Get the grammar's table prefix.

getValue()  : string

Get the value of a raw expression.

isExpression()  : bool

Determine if the given value is a raw expression.

parameter()  : string

Get the appropriate query parameter place-holder for a value.

parameterize()  : string

Create query parameter place-holders for an array.

prepareBindingsForDelete()  : array<string|int, mixed>

Prepare the bindings for a delete statement.

prepareBindingsForUpdate()  : array<string|int, mixed>

Prepare the bindings for an update statement.

setTablePrefix()  : $this

Set the grammar's table prefix.

supportsSavepoints()  : bool

Determine if the grammar supports savepoints.

wrap()  : string

Wrap a value in keyword identifiers.

wrapArray()  : array<string|int, mixed>

Wrap an array of values.

wrapTable()  : string

Wrap a table in keyword identifiers.

compileAggregate()  : string

Compile an aggregated select clause.

compileAnsiOffset()  : string

Create a full ANSI offset clause for the query.

compileBasicHaving()  : string

Compile a basic having clause.

compileColumns()  : string|null

Compile the "select *" portion of the query.

compileComponents()  : array<string|int, mixed>

Compile the components necessary for a select clause.

compileDeleteWithJoins()  : string

Compile a delete statement with joins into SQL.

compileFrom()  : string

Compile the "from" portion of the query.

compileGroups()  : string

Compile the "group by" portions of the query.

compileHaving()  : string

Compile a single having clause.

compileHavings()  : string

Compile the "having" portions of the query.

compileJoins()  : string

Compile the "join" portions of the query.

compileLimit()  : string

Compile the "limit" portions of the query.

compileLock()  : string

Compile the lock into SQL.

compileOffset()  : string

Compile the "offset" portions of the query.

compileOrders()  : string

Compile the "order by" portions of the query.

compileOrdersToArray()  : array<string|int, mixed>

Compile the query orders to an array.

compileOver()  : string

Compile the over statement for a table expression.

compileRowConstraint()  : string

Compile the limit / offset row constraint for a query.

compileTableExpression()  : string

Compile a common table expression for a query.

compileUnion()  : string

Compile a single union statement.

compileUnions()  : string

Compile the "union" queries attached to the main query.

compileWheres()  : string

Compile the "where" portions of the query.

compileWheresToArray()  : array<string|int, mixed>

Get an array of all the where clauses for the query.

concatenate()  : string

Concatenate an array of segments, removing empties.

concatenateWhereClauses()  : string

Format the where clause statements into one string.

dateBasedWhere()  : string

Compile a date based where clause.

parseUpdateTable()  : array<string|int, mixed>

Get the table and alias for the given table.

removeLeadingBoolean()  : string

Remove the leading boolean from a statement.

whereBasic()  : string

Compile a basic where clause.

whereBetween()  : string

Compile a "between" where clause.

whereColumn()  : string

Compile a where clause comparing two columns.

whereDate()  : string

Compile a "where date" clause.

whereDay()  : string

Compile a "where day" clause.

whereExists()  : string

Compile a where exists clause.

whereIn()  : string

Compile a "where in" clause.

whereInSub()  : string

Compile a where in sub-select clause.

whereMonth()  : string

Compile a "where month" clause.

whereNested()  : string

Compile a nested where clause.

whereNotExists()  : string

Compile a where exists clause.

whereNotIn()  : string

Compile a "where not in" clause.

whereNotInSub()  : string

Compile a where not in sub-select clause.

whereNotNull()  : string

Compile a "where not null" clause.

whereNull()  : string

Compile a "where null" clause.

whereRaw()  : string

Compile a raw where clause.

whereSub()  : string

Compile a where condition with a sub-select.

whereTime()  : string

Compile a "where time" clause.

whereYear()  : string

Compile a "where year" clause.

wrapAliasedValue()  : string

Wrap a value that has an alias.

wrapSegments()  : string

Wrap the given value segments.

wrapTableValuedFunction()  : string

Wrap a table in keyword identifiers.

wrapValue()  : string

Wrap a single string in keyword identifiers.