| Methods |
public
|
compileSelect(Builder $query): string
Compile a select query into SQL.
Compile a select query into SQL.
|
#
|
protected
|
compileComponents(Builder $query): array
Compile the components necessary for a select clause.
Compile the components necessary for a select clause.
|
#
|
protected
|
compileAggregate(Builder $query, array $aggregate): string
Compile an aggregated select clause.
Compile an aggregated select clause.
|
#
|
protected
|
compileColumns(Builder $query, array $columns): string|null
Compile the "select *" portion of the query.
Compile the "select *" portion of the query.
|
#
|
protected
|
compileFrom(Builder $query, string $table): string
Compile the "from" portion of the query.
Compile the "from" portion of the query.
|
#
|
protected
|
compileJoins(Builder $query, array $joins): string
Compile the "join" portions of the query.
Compile the "join" portions of the query.
|
#
|
public
|
compileJoinLateral(JoinLateralClause $join, string $expression): string
Compile a "lateral join" clause.
Compile a "lateral join" clause.
Throws
|
#
|
public
|
compileWheres(Builder $query): string
Compile the "where" portions of the query.
Compile the "where" portions of the query.
|
#
|
protected
|
compileWheresToArray(Builder $query): array
Get an array of all the where clauses for the query.
Get an array of all the where clauses for the query.
|
#
|
protected
|
concatenateWhereClauses(Builder $query, array $sql): string
Format the where clause statements into one string.
Format the where clause statements into one string.
|
#
|
protected
|
whereRaw(Builder $query, array $where): string
Compile a raw where clause.
Compile a raw where clause.
|
#
|
protected
|
whereBasic(Builder $query, array $where): string
Compile a basic where clause.
Compile a basic where clause.
|
#
|
protected
|
whereBitwise(Builder $query, array $where): string
Compile a bitwise operator where clause.
Compile a bitwise operator where clause.
|
#
|
protected
|
whereLike(Builder $query, array $where): string
Compile a "where like" clause.
Compile a "where like" clause.
|
#
|
protected
|
whereIn(Builder $query, array $where): string
Compile a "where in" clause.
Compile a "where in" clause.
|
#
|
protected
|
whereNotIn(Builder $query, array $where): string
Compile a "where not in" clause.
Compile a "where not in" clause.
|
#
|
protected
|
whereNotInRaw(Builder $query, array $where): string
Compile a "where not in raw" clause.
Compile a "where not in raw" clause.
For safety, whereIntegerInRaw ensures this method is only used with integer values.
|
#
|
protected
|
whereInRaw(Builder $query, array $where): string
Compile a "where in raw" clause.
Compile a "where in raw" clause.
For safety, whereIntegerInRaw ensures this method is only used with integer values.
|
#
|
protected
|
whereNull(Builder $query, array $where): string
Compile a "where null" clause.
Compile a "where null" clause.
|
#
|
protected
|
whereNotNull(Builder $query, array $where): string
Compile a "where not null" clause.
Compile a "where not null" clause.
|
#
|
protected
|
whereBetween(Builder $query, array $where): string
Compile a "between" where clause.
Compile a "between" where clause.
|
#
|
protected
|
whereBetweenColumns(Builder $query, array $where): string
Compile a "between" where clause.
Compile a "between" where clause.
|
#
|
protected
|
whereDate(Builder $query, array $where): string
Compile a "where date" clause.
Compile a "where date" clause.
|
#
|
protected
|
whereTime(Builder $query, array $where): string
Compile a "where time" clause.
Compile a "where time" clause.
|
#
|
protected
|
whereDay(Builder $query, array $where): string
Compile a "where day" clause.
Compile a "where day" clause.
|
#
|
protected
|
whereMonth(Builder $query, array $where): string
Compile a "where month" clause.
Compile a "where month" clause.
|
#
|
protected
|
whereYear(Builder $query, array $where): string
Compile a "where year" clause.
Compile a "where year" clause.
|
#
|
protected
|
dateBasedWhere(string $type, Builder $query, array $where): string
Compile a date based where clause.
Compile a date based where clause.
|
#
|
protected
|
whereColumn(Builder $query, array $where): string
Compile a where clause comparing two columns.
Compile a where clause comparing two columns.
|
#
|
protected
|
whereNested(Builder $query, array $where): string
Compile a nested where clause.
Compile a nested where clause.
|
#
|
protected
|
whereSub(Builder $query, array $where): string
Compile a where condition with a sub-select.
Compile a where condition with a sub-select.
|
#
|
protected
|
whereExists(Builder $query, array $where): string
Compile a where exists clause.
Compile a where exists clause.
|
#
|
protected
|
whereNotExists(Builder $query, array $where): string
Compile a where exists clause.
Compile a where exists clause.
|
#
|
protected
|
whereRowValues(Builder $query, array $where): string
Compile a where row values condition.
Compile a where row values condition.
|
#
|
protected
|
whereJsonBoolean(Builder $query, array $where): string
Compile a "where JSON boolean" clause.
Compile a "where JSON boolean" clause.
|
#
|
protected
|
whereJsonContains(Builder $query, array $where): string
Compile a "where JSON contains" clause.
Compile a "where JSON contains" clause.
|
#
|
protected
|
compileJsonContains(string $column, string $value): string
Compile a "JSON contains" statement into SQL.
Compile a "JSON contains" statement into SQL.
Throws
|
#
|
protected
|
whereJsonOverlaps(Builder $query, array $where): string
Compile a "where JSON overlaps" clause.
Compile a "where JSON overlaps" clause.
|
#
|
protected
|
compileJsonOverlaps(string $column, string $value): string
Compile a "JSON overlaps" statement into SQL.
Compile a "JSON overlaps" statement into SQL.
Throws
|
#
|
public
|
prepareBindingForJsonContains(mixed $binding): string
Prepare the binding for a "JSON contains" statement.
Prepare the binding for a "JSON contains" statement.
|
#
|
protected
|
whereJsonContainsKey(Builder $query, array $where): string
Compile a "where JSON contains key" clause.
Compile a "where JSON contains key" clause.
|
#
|
protected
|
compileJsonContainsKey(string $column): string
Compile a "JSON contains key" statement into SQL.
Compile a "JSON contains key" statement into SQL.
Throws
|
#
|
protected
|
whereJsonLength(Builder $query, array $where): string
Compile a "where JSON length" clause.
Compile a "where JSON length" clause.
|
#
|
protected
|
compileJsonLength(string $column, string $operator, string $value): string
Compile a "JSON length" statement into SQL.
Compile a "JSON length" statement into SQL.
Throws
|
#
|
public
|
compileJsonValueCast(string $value): string
Compile a "JSON value cast" statement into SQL.
Compile a "JSON value cast" statement into SQL.
|
#
|
public
|
whereFullText(Builder $query, array $where): string
Compile a "where fulltext" clause.
Compile a "where fulltext" clause.
|
#
|
public
|
whereExpression(Builder $query, array $where): string
Compile a clause based on an expression.
Compile a clause based on an expression.
|
#
|
protected
|
compileGroups(Builder $query, array $groups): string
Compile the "group by" portions of the query.
Compile the "group by" portions of the query.
|
#
|
protected
|
compileHavings(Builder $query): string
Compile the "having" portions of the query.
Compile the "having" portions of the query.
|
#
|
protected
|
compileHaving(array $having): string
Compile a single having clause.
Compile a single having clause.
|
#
|
protected
|
compileBasicHaving(array $having): string
Compile a basic having clause.
Compile a basic having clause.
|
#
|
protected
|
compileHavingBetween(array $having): string
Compile a "between" having clause.
Compile a "between" having clause.
|
#
|
protected
|
compileHavingNull(array $having): string
Compile a having null clause.
Compile a having null clause.
|
#
|
protected
|
compileHavingNotNull(array $having): string
Compile a having not null clause.
Compile a having not null clause.
|
#
|
protected
|
compileHavingBit(array $having): string
Compile a having clause involving a bit operator.
Compile a having clause involving a bit operator.
|
#
|
protected
|
compileHavingExpression(array $having): string
Compile a having clause involving an expression.
Compile a having clause involving an expression.
|
#
|
protected
|
compileNestedHavings(array $having): string
Compile a nested having clause.
Compile a nested having clause.
|
#
|
protected
|
compileOrders(Builder $query, array $orders): string
Compile the "order by" portions of the query.
Compile the "order by" portions of the query.
|
#
|
protected
|
compileOrdersToArray(Builder $query, array $orders): array
Compile the query orders to an array.
Compile the query orders to an array.
|
#
|
public
|
compileRandom(string|int $seed): string
Compile the random statement into SQL.
Compile the random statement into SQL.
|
#
|
protected
|
compileLimit(Builder $query, int $limit): string
Compile the "limit" portions of the query.
Compile the "limit" portions of the query.
|
#
|
protected
|
compileGroupLimit(Builder $query): string
Compile a group limit clause.
Compile a group limit clause.
|
#
|
protected
|
compileRowNumber(string $partition, string $orders): string
Compile a row number clause.
Compile a row number clause.
|
#
|
protected
|
compileOffset(Builder $query, int $offset): string
Compile the "offset" portions of the query.
Compile the "offset" portions of the query.
|
#
|
protected
|
compileUnions(Builder $query): string
Compile the "union" queries attached to the main query.
Compile the "union" queries attached to the main query.
|
#
|
protected
|
compileUnion(array $union): string
Compile a single union statement.
Compile a single union statement.
|
#
|
protected
|
wrapUnion(string $sql): string
Wrap a union subquery in parentheses.
Wrap a union subquery in parentheses.
|
#
|
protected
|
compileUnionAggregate(Builder $query): string
Compile a union aggregate query into SQL.
Compile a union aggregate query into SQL.
|
#
|
public
|
compileExists(Builder $query): string
Compile an exists statement into SQL.
Compile an exists statement into SQL.
|
#
|
public
|
compileInsert(Builder $query, array $values): string
Compile an insert statement into SQL.
Compile an insert statement into SQL.
|
#
|
public
|
compileInsertOrIgnore(Builder $query, array $values): string
Compile an insert ignore statement into SQL.
Compile an insert ignore statement into SQL.
Throws
|
#
|
public
|
compileInsertGetId(Builder $query, array $values, string $sequence): string
Compile an insert and get ID statement into SQL.
Compile an insert and get ID statement into SQL.
|
#
|
public
|
compileInsertUsing(Builder $query, array $columns, string $sql): string
Compile an insert statement using a subquery into SQL.
Compile an insert statement using a subquery into SQL.
|
#
|
public
|
compileInsertOrIgnoreUsing(Builder $query, array $columns, string $sql): string
Compile an insert ignore statement using a subquery into SQL.
Compile an insert ignore statement using a subquery into SQL.
Throws
|
#
|
public
|
compileUpdate(Builder $query, array $values): string
Compile an update statement into SQL.
Compile an update statement into SQL.
|
#
|
protected
|
compileUpdateColumns(Builder $query, array $values): string
Compile the columns for an update statement.
Compile the columns for an update statement.
|
#
|
protected
|
compileUpdateWithoutJoins(Builder $query, string $table, string $columns, string $where): string
Compile an update statement without joins into SQL.
Compile an update statement without joins into SQL.
|
#
|
protected
|
compileUpdateWithJoins(Builder $query, string $table, string $columns, string $where): string
Compile an update statement with joins into SQL.
Compile an update statement with joins into SQL.
|
#
|
public
|
compileUpsert(Builder $query, array $values, array $uniqueBy, array $update): string
Compile an "upsert" statement into SQL.
Compile an "upsert" statement into SQL.
Throws
|
#
|
public
|
prepareBindingsForUpdate(array $bindings, array $values): array
Prepare the bindings for an update statement.
Prepare the bindings for an update statement.
|
#
|
public
|
compileDelete(Builder $query): string
Compile a delete statement into SQL.
Compile a delete statement into SQL.
|
#
|
protected
|
compileDeleteWithoutJoins(Builder $query, string $table, string $where): string
Compile a delete statement without joins into SQL.
Compile a delete statement without joins into SQL.
|
#
|
protected
|
compileDeleteWithJoins(Builder $query, string $table, string $where): string
Compile a delete statement with joins into SQL.
Compile a delete statement with joins into SQL.
|
#
|
public
|
prepareBindingsForDelete(array $bindings): array
Prepare the bindings for a delete statement.
Prepare the bindings for a delete statement.
|
#
|
public
|
compileTruncate(Builder $query): array
Compile a truncate table statement into SQL.
Compile a truncate table statement into SQL.
|
#
|
protected
|
compileLock(Builder $query, bool|string $value): string
Compile the lock into SQL.
Compile the lock into SQL.
|
#
|
public
|
compileThreadCount(): string|null
Compile a query to get the number of open connections for a database.
Compile a query to get the number of open connections for a database.
|
#
|
public
|
supportsSavepoints(): bool
Determine if the grammar supports savepoints.
Determine if the grammar supports savepoints.
|
#
|
public
|
compileSavepoint(string $name): string
Compile the SQL statement to define a savepoint.
Compile the SQL statement to define a savepoint.
|
#
|
public
|
compileSavepointRollBack(string $name): string
Compile the SQL statement to execute a savepoint rollback.
Compile the SQL statement to execute a savepoint rollback.
|
#
|
protected
|
wrapJsonBooleanSelector(string $value): string
Wrap the given JSON selector for boolean values.
Wrap the given JSON selector for boolean values.
|
#
|
protected
|
wrapJsonBooleanValue(string $value): string
Wrap the given JSON boolean value.
Wrap the given JSON boolean value.
|
#
|
protected
|
concatenate(array $segments): string
Concatenate an array of segments, removing empties.
Concatenate an array of segments, removing empties.
|
#
|
protected
|
removeLeadingBoolean(string $value): string
Remove the leading boolean from a statement.
Remove the leading boolean from a statement.
|
#
|
public
|
substituteBindingsIntoRawSql(string $sql, array $bindings): string
Substitute the given bindings into the given raw SQL query.
Substitute the given bindings into the given raw SQL query.
|
#
|
public
|
getOperators(): array
Get the grammar specific operators.
Get the grammar specific operators.
|
#
|
public
|
getBitwiseOperators(): array
Get the grammar specific bitwise operators.
Get the grammar specific bitwise operators.
|
#
|