Initialize the query using a From instance.
Used for accessing columns in tables.
An Escaper matching the database type (e.g. MySQLEscaper or MSSQLEscaper). Used when escaping column names in compiled conditions.
An Executer instance that matches the database type (e.g. MySQLExecuter).
A From instance which holds the base table, all joined-in tables, and the where clause.
An OrderBy instance which is optionally used to order the query results.
Used for accessing columns in tables.
An Escaper matching the database type (e.g. MySQLEscaper or MSSQLEscaper). Used when escaping column names in compiled conditions.
An Executer instance that matches the database type (e.g. MySQLExecuter).
A From instance which holds the base table, all joined-in tables, and the where clause.
An OrderBy instance which is optionally used to order the query results.
Build the query.
The string-representation of the query to execute along with query parameters.
Execute the query and return an array of results of type T.
A promise that shall be resolved with the normalized query results of type T. If an error occurs while executing the query, the returned promise shall be rejected with the unmodified error.
Get the SELECT portion of the query string.
Limit the number of rows returned.
The number of rows to return.
Limit the number of rows returned with an offset.
The number of rows to return.
Order by one or more columns.
A list of fully-qualified properties in the form <table-alias>.<property>, or an array of OrderByType with the fully-qualified property and direction.
Select columns manually.
An optional set of columns to select. Each argument should be a fully-qualified property name in the form <table-alias>.<property>. If no columns are specified, then all columns are selected.
Get the SQL that represents the query.
The SQL representing the select statement.
Generated using TypeDoc
Represents a SELECT query for MySQL.