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.

executeInternal

open override fun JdbcPreparedStatementApi.executeInternal(transaction: JdbcTransaction): JdbcResult?

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.

fetchBatchedResults

fun fetchBatchedResults(batchSize: Int = 1000, sortOrder: SortOrder = SortOrder.ASC): Iterable<Iterable<ResultRow>>

Iterates over multiple executions of this SELECT query with its LIMIT clause set to batchSize until the amount of results retrieved from the database is less than batchSize.

fetchSize

fun fetchSize(n: Int): Query

forUpdate

open override fun forUpdate(option: ForUpdateOption): Query

Returns a new SizedIterable with a locking read for the elements according to the rules specified by option.

groupBy

fun groupBy(vararg columns: Expression<*>): Query

hasCustomForUpdateState

fun hasCustomForUpdateState(): Boolean

having

fun having(op: SqlExpressionBuilder.() -> Op<Boolean>): Query

intersect

fun AbstractQuery<*>.intersect(other: Query): Intersect

Returns only results from this query that are common to the results of other, WITHOUT including any duplicates.

isForUpdate

fun isForUpdate(): Boolean

iterator

open operator override fun iterator(): Iterator<ResultRow>

limit

open override fun limit(count: Int): Query

Modifies this query to return only count results.

mapLazy

infix fun <T, R> SizedIterable<T>.mapLazy(f: (T) -> R): SizedIterable<R>

Returns a SizedIterable containing the lazily evaluated results of applying the function f to each original element.

notForUpdate

open override fun notForUpdate(): Query

Returns a new SizedIterable without any locking read for the elements.

offset

open override fun offset(start: Long): Query

Modifies this query to return only results starting after the specified start.

orderBy

open override fun orderBy(vararg order: Pair<Expression<*>, SortOrder>): Query

Modifies this query to sort results according to the provided order of expressions.

fun orderBy(column: Expression<*>, order: SortOrder = SortOrder.ASC): Query

Modifies this query to sort results by the specified column, according to the provided order.

orHaving

fun Query.orHaving(orPart: SqlExpressionBuilder.() -> Op<Boolean>): Query

Mutate Query instance and add orPart to having condition with or operator.

orWhere

fun Query.orWhere(orPart: SqlExpressionBuilder.() -> Op<Boolean>): Query

Mutate Query instance and add orPart to where condition with or operator.

prepared

open fun prepared(transaction: JdbcTransaction, sql: String): JdbcPreparedStatementApi

Uses a transaction connection and an sql string representation to return a precompiled SQL statement, stored as an implementation of JdbcPreparedStatementApi.

prepareSQL

open fun prepareSQL(builder: QueryBuilder): String

open override fun prepareSQL(transaction: Transaction, prepared: Boolean): String

union

fun AbstractQuery<*>.union(other: Query): Union

Combines all results from this query with the results of other, WITHOUT including duplicates.

unionAll

fun AbstractQuery<*>.unionAll(other: Query): UnionAll

Combines all results from this query with the results of other, WITH duplicates included.

where

fun where(predicate: SqlExpressionBuilder.() -> Op<Boolean>): Query

fun where(predicate: Op<Boolean>): Query

Appends a WHERE clause with the specified predicate to this SELECT query.

withDistinct

open fun withDistinct(value: Boolean): Query

withDistinctOn

fun withDistinctOn(vararg columns: Column<*>): Query

fun withDistinctOn(vararg columns: Pair<Column<*>, SortOrder>): Query

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.