Query
Class representing an SQL SELECT
statement on which query clauses can be built.
Properties
Functions
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.
Returns a new SizedIterable with a locking read for the elements according to the rules specified by option.
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 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.
Specifies that the SELECT
query should retrieve distinct results based on the given list of columns with sort orders. This method sets a DISTINCT ON
clause and may reorder the results as indicated.