UnionAll
Represents an SQL operation that combines all results from two queries, with duplicates included.
Properties
The SQL statement on the left-hand side of the set operator.
Whether the SQL statement is meant to be performed as part of a batch execution.
The SQL keyword representing the set operation.
The stored list of columns and their SortOrder for an ORDER BY
clause in this query.
Functions
Returns a new SizedIterable that is a copy of the original.
Copies all stored properties of this SELECT
query into the properties of other.
Executes the SQL statement directly in the provided transaction and returns the generated result, or null
if either no result was retrieved or if the transaction blocked statement execution.
Determines the exact way that an SQL statement is executed in a transaction and applies any necessary logic before returning the result generated by the executed statement.
Modifies the number of results that should be fetched when this query is executed.
Returns a new SizedIterable with a locking read for the elements according to the rules specified by option.
Modifies this query to return only count results.
Returns a SizedIterable containing the lazily evaluated results of applying the function f to each original element.
Returns a new SizedIterable without any locking read for the elements.
Modifies this query to return only results starting after the specified start.
Modifies this query to sort results according to the provided order of expressions.
Uses a transaction connection and an sql string representation to return a precompiled SQL statement, stored as an implementation of PreparedStatementApi.
Returns the string representation of an SQL statement.
Returns the string representation of an SQL query, generated by appending SQL expressions to a QueryBuilder.
Modifies this query to retrieve only distinct results if value is set to true
.