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.
Specify the connection name or instance to execute the query on.
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.
Include the given field (and optional alias) in the query.
Include the given fields in the query.
Get a copy of this builder with its values finalized.
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.
function
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.
Call the make() method on the global container.
Allow the query to return non-distinct rows. (Undoes distinct().)
Alias of skip().
Apply an OR WHERE constraint to the query.
Apply an OR WHERE IN constraint to the query, escaping the values in the set.
Apply an OR WHERE NOT constraint to the query.
Apply an OR WHERE NOT IN constraint to the query, escaping the values in the set.
Apply an OR WHERE constraint to the query, without escaping operand. Prefer orWhere().
Order the query by the given field.
Order the query by the given field, ascending.
Order the query by the given field, descending.
Apply skip() and take() calls to retrieve the records that should appear on
the pageNum page, assuming each page has pageSize many records.
Set the query manually. Overrides any builder methods.
Alias of fields().
Alias of fields().
Skip the first rows many rows in the result set.
Alias of from().
Alias of limit().
Run an UPDATE query for all rows matched by this query, setting the given data.
Apply a new WHERE constraint to the query.
Apply a WHERE IN constraint to the query, escaping the values in the set.
Apply a new WHERE NOT constraint to the query.
Apply a WHERE NOT IN constraint to the query, escaping the values in the set.
Apply a new WHERE constraint to the query, without escaping operand. Prefer where().
extollo (v. latin) - to lift up, to elevate
Extollo is a free & libre application framework in TypeScript.
Implementation of the abstract builder class that returns simple QueryRow objects.