Converts this builder to a StepBuilder, which enables lazy execution within a transaction. Returns a wrapper with terminal methods that create TransactionStep instead of executing the query.

buildReturningClause

protected fun buildReturningClause(): String

Builds the SQL fragment for the RETURNING clause.

buildSql

open override fun buildSql(): String

Builds the final SQL query based on the builder's state. Must be implemented by each concrete builder class.

buildWithClause

protected fun buildWithClause(): String

Creates a formatted SQL fragment for the WITH clause based on added queries. Each CTE is on a new line for readability.

copy

open override fun copy(): DatabaseUpdateQueryBuilder

copyBaseStateFrom

protected fun copyBaseStateFrom(source: AbstractQueryBuilder<UpdateQueryBuilder>)

Copies state from another builder of the same type. Used by copy() methods in derived classes.

execute

open override fun execute(params: Map<String, Any?>): DataResult<Int>

Executes a modifying query (without RETURNING) and returns the number of affected rows. Throws an exception if a RETURNING clause was used - in that case, use toList(), toSingle(), etc. methods instead.

from

open override fun from(tables: String): UpdateQueryBuilder

internalOptions

internal fun internalOptions(): InternalQueryOptions

Creates InternalQueryOptions for current query state. Should be called once per terminal method.

iterate

open override fun iterate(fetchSize: Int): IterativeTerminalMethods

options

open override fun options(block: QueryOptionsBuilder.() -> Unit): UpdateQueryBuilder

recursive

fun recursive(): UpdateQueryBuilder

Marks the WITH clause as recursive.

returning

fun returning(vararg columns: String): UpdateQueryBuilder

Adds a RETURNING clause to the modifying query (INSERT, UPDATE, DELETE).

setExpression

open override fun setExpression(column: String, value: String): UpdateQueryBuilder

setExpressions

open override fun setExpressions(values: Map<String, String>): UpdateQueryBuilder

setValue

open override fun setValue(column: String): UpdateQueryBuilder

setValues

open override fun setValues(values: List<String>): UpdateQueryBuilder

open override fun setValues(values: Map<String, Any?>): UpdateQueryBuilder

toColumn

open override fun <T> toColumn(targetType: KType, params: Map<String, Any?>): DataResult<List<T>>

Executes the query and returns a list of values from the first column of all rows.

toField

open override fun <T> toField(targetType: KType, params: Map<String, Any?>): DataResult<T>

Executes the query and returns the value from the first column of the first row.

toFieldStrict

open override fun <T> toFieldStrict(targetType: KType, params: Map<String, Any?>): DataResult<T>

Executes the query and returns the value from the first column of the first row. Always fails on empty result.

toList

open override fun toList(params: Map<String, Any?>): DataResult<List<Map<String, Any?>>>

Executes the query and returns a list of rows as List<Map<String, Any?>>.

toListOf

open override fun <T : Any> toListOf(params: Map<String, Any?>, mapper: DataMapper<T>): DataResult<List<T>>

Executes the query and maps results to a list of objects using the provided mapper.

open override fun <T : Any> toListOf(kType: KType, params: Map<String, Any?>): DataResult<List<T>>

Executes the query and maps results to a list of objects of the given type.

toSingle

open override fun toSingle(params: Map<String, Any?>): DataResult<Map<String, Any?>?>

Executes the query and returns a single row as Map<String, Any?>?.

toSingleOf

open override fun <T> toSingleOf(kType: KType, params: Map<String, Any?>): DataResult<T>

Executes the query and maps the result to a single object of the given type.

open override fun <T> toSingleOf(kType: KType, params: Map<String, Any?>, mapper: DataMapper<T & Any>): DataResult<T>

Executes the query and maps the result to a single object using the provided mapper.

toSingleStrict

open override fun toSingleStrict(params: Map<String, Any?>): DataResult<Map<String, Any?>>

Executes the query and returns the first row. Always fails on empty result.

toSql

open override fun toSql(): String

Returns the generated SQL string without executing the query.

toString

open override fun toString(): String

where

open override fun where(condition: String): UpdateQueryBuilder

with

fun with(name: String, query: String): UpdateQueryBuilder

Adds a query to the WITH clause (Common Table Expression).