SQL

Less than 1 minute

Trait providing SQL-related utility methods for database drivers.

trait SQL

Includes query builder initialization, database creation, privilege management, and type/value helpers.

Properties

public string $schemaName

Initializes the query builder with an optional schema name.

public initQueryBuilder(?string $schemaName): void

Parameter	Type	Description
`$schemaName`	`string`	the schema name to use for queries

Returns a new SQL query builder instance, optionally setting reserved words.

public getQueryBuilder(): QueryBuilder

Creates a new database with the given name.

public createDatabase(string $name): bool

Parameter	Type	Description
`$name`	`string`	the name of the database to create

public grant(string $privilege, string $to, string $object): bool

public revoke(string $privilege, string $object, string $from): bool

Fixes or transforms a value before using it in SQL queries.

protected fixValue(mixed $value): mixed

Override in implementing classes to provide custom value handling.

Parameter	Type	Description
`$value`	`mixed`	the value to fix or transform

Returns the SQL data type string, optionally with length and array notation.

protected type(?string $dataType, ?int $length): string

Parameter	Type	Description
`$dataType`	`string`	the base data type
`$length`	`int`	the length for the data type, if applicable

Generated by Hazaar API Doc Generator on Tue, 21 Apr 2026 04:00:24 +0000