Select Query Builder

Query builder for the SQL SELECT statement.

engine

Returns the database engine used by this query builder. This is used to execute the query directly from this builder. You can also set this property manually.
Copy
Copy

build()

Converts the class data to object.
Copy

from()

FROM clause.

Usage

Copy

Example

Copy
Copy

join()

JOIN clause.

Usage

Copy

Example

Copy
Copy

limit()

LIMIT clause.

Usage

Copy

Example

Copy

offset()

OFFSET clause.

Usage

Copy

Example

Copy

order()

ORDER BY clause.

Usage

Copy

Example

Copy
Copy

query()

Convert the builder to a query object.

Usage

Copy

Example

Copy

then()

Makes class awaitable. Should get the query and values and call the action.

Usage

Copy

Example

Copy

where()

WHERE clause.

Usage

Copy

Example

Copy