A base class that facilitates building database queries using a fluent interface.
This can be specialized by child-classes to yield query results of the given type
Constraints applied to this query.
Raw SQL to use instead. Overrides builder methods.
The connection on which the query should be executed.
If true, the query should refer to distinct records.
The fields to query from the table.
Array of SQL group-by clauses.
Array of SQL order-by clauses.
The number of records to skip before the result set.
The max number of records to include in the result set.
The source table to query from.
The global application instance.
Get the constraints applied to this query.
True if the query should be DISTINCT
Get the fields that should be included in this query.
Get the SQL group-by clauses applied to this query.
Get the SQL order-by clauses applied to this query.
Get the skip/take values of this query.
Get the raw SQL overriding the builder methods, if it exists.
Get the source table for this query.
Get the global Application.
Remove all selected fields from this query.
Clone the current query to a new AbstractBuilder instance with the same properties.
Get the global Container.
Execute a DELETE based on this query.
Make the query return only distinct rows.
Returns true if at least one row matches the current query.
Get the first record matched by this query, if it exists.
Set the source table (and optional alias) for this query.
Get an async collection of the rows resulting from this query.
Get the method with the given name from this class, bound to this class.
Create a new, empty, instance of the current builder.
Get a result iterable for the built query.
Apply one or more GROUP-BY clauses to the query.
Insert the given rows into the table for this query, returning the fields specified in this query.
Get a result iterable for the rows of this query.
Limit the query to a maximum number of rows.
make() method on the global container.
Allow the query to return non-distinct rows. (Undoes
Order the query by the given field, ascending.
Order the query by the given field, descending.
take() calls to retrieve the records that should appear on
pageNum page, assuming each page has
pageSize many records.
Set the query manually. Overrides any builder methods.
Skip the first
rows many rows in the result set.