public supportsReleaseSavepoints () Checks whether the platform supports releasing savepoints.

public sharedLock (mixed $sqlQuery) Returns a SQL modified with a LOCK IN SHARE MODE clause $sql = $dialect->sharedLock('SELECT * FROM robots'); echo $sql; // SELECT * FROM robots LOCK IN SHARE MODE

Db\Dialect::select

public select (array $definition) Builds a SELECT statement

Db\Dialect::rollbackSavepoint

public rollbackSavepoint (mixed $name) Generate SQL to rollback a savepoint

Db\Dialect::releaseSavepoint

public releaseSavepoint (mixed $name) Generate SQL to release a savepoint

Db\Dialect::registerCustomFunction

public registerCustomFunction (mixed $name, mixed $customFunction) Registers custom SQL functions

Db\Dialect::limit

public limit (mixed $sqlQuery, mixed $number) Generates the SQL for LIMIT clause $sql = $dialect->limit('SELECT * FROM robots', 10); echo $sql; // SELECT * FROM robots LIMIT 10 $sql = $dialect->limit('SELECT * FROM robots', [10, 50]); echo $sql; // SELECT * FROM robots LIMIT 10 OFFSET 50

Db\Dialect::getSqlTable

final public getSqlTable (mixed $table, [mixed $escapeChar]) Transform an intermediate representation of a schema/table into a database system valid expression

Db\Dialect::getSqlExpression

public getSqlExpression (array $expression, [mixed $escapeChar], [mixed $bindCounts]) Transforms an intermediate representation for an expression into a database system valid expression

Db\Dialect::getSqlColumn

final public getSqlColumn (mixed $column, [mixed $escapeChar], [mixed $bindCounts]) Resolve Column expressions