PostgresGrammar

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

Compile a basic where clause.

Parameters

• $query Builder
• $where array

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

Compile a bitwise operator where clause.

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

# dateBasedWhere ( $type , Builder $query , $where ) : string

Compile a date based where clause.

Parameters

• $type string
• $query Builder
• $where array

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

Compile a "where fulltext" clause.

Parameters

• $query Builder
• $where array

# validFullTextLanguages ( ) : array

Get an array of valid full text languages.

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

Compile the "select *" portion of the query.

Parameters

• $query Builder
• $columns array

# compileJsonContains ( $column , $value ) : string

Compile a "JSON contains" statement into SQL.

Parameters

• $column string
• $value string

# compileJsonContainsKey ( $column ) : string

Compile a "JSON contains key" statement into SQL.

Parameters

• $column string

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

Compile a "JSON length" statement into SQL.

Parameters

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

# compileHaving ( array $having ) : string

Compile a single having clause.

Parameters

• $having array

# compileHavingBitwise ( $having ) : string

Compile a having clause involving a bitwise operator.

Parameters

• $having array

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

Compile the lock into SQL.

Parameters

• $query Builder
• $value bool|string

# compileInsertOrIgnore ( Builder $query , array $values ) : string

Compile an insert ignore statement into SQL.

Parameters

• $query Builder
• $values array

# compileInsertGetId ( Builder $query , $values , $sequence ) : string

Compile an insert and get ID statement into SQL.

Parameters

• $query Builder
• $values array
• $sequence string

# compileUpdate ( Builder $query , array $values ) : string

Compile an update statement into SQL.

Parameters

• $query Builder
• $values array

# compileUpdateColumns ( Builder $query , array $values ) : string

Compile the columns for an update statement.

Parameters

• $query Builder
• $values array

# 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

# compileJsonUpdateColumn ( $key , $value ) : string

Prepares a JSON column being updated using the JSONB_SET function.

Parameters

• $key string
• $value mixed

# compileUpdateFrom ( Builder $query , $values ) : string

Compile an update from statement into SQL.

Parameters

• $query Builder
• $values array

# compileUpdateWheres ( Builder $query ) : string

Compile the additional where clauses for updates with joins.

Parameters

• $query Builder

# compileUpdateJoinWheres ( Builder $query ) : string

Compile the "join" clause where clauses for an update.

Parameters

• $query Builder

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

Prepare the bindings for an update statement.

Parameters

• $bindings array
• $values array

# compileUpdateWithJoinsOrLimit ( Builder $query , array $values ) : string

Compile an update statement with joins or limit into SQL.

Parameters

• $query Builder
• $values array

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

Prepare the bindings for an update statement.

Parameters

• $bindings array
• $values array

# compileDelete ( Builder $query ) : string

Compile a delete statement into SQL.

Parameters

• $query Builder

# compileDeleteWithJoinsOrLimit ( Builder $query ) : string

Compile a delete statement with joins or limit into SQL.

Parameters

• $query Builder

# compileTruncate ( Builder $query ) : array

Compile a truncate table statement into SQL.

Parameters

• $query Builder

# wrapJsonSelector ( $value ) : string

Wrap the given JSON selector.

Parameters

• $value string

# wrapJsonBooleanSelector ( $value ) : string

Wrap the given JSON selector for boolean values.

Parameters

• $value string

# wrapJsonBooleanValue ( $value ) : string

Wrap the given JSON boolean value.

Parameters

• $value string

# wrapJsonPathAttributes ( $path ) : array

Wrap the attributes of the given JSON path.

Parameters

• $path array

# parseJsonPathArrayKeys ( $attribute ) : array

Parse the given JSON path attribute for array keys.

Parameters

• $attribute string

# substituteBindingsIntoRawSql ( $sql , $bindings ) : string

Substitute the given bindings into the given raw SQL query.

Parameters

• $sql string
• $bindings array