DeleteQueryBuilder

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

Switches the builder to streaming mode, optimal for large datasets. Requires using streaming-specific terminal methods like forEachRow(). REQUIRES ACTIVE TRANSACTION. This method must be called inside a DataAccess.transaction { ... } block. Otherwise, PostgreSQL will ignore fetchSize and load everything into RAM.

Switches the builder to asynchronous mode. Requires providing a CoroutineScope in which operations will be launched.

Creates and returns a deep copy of this builder. Returns the concrete builder type (e.g., SelectQueryBuilder), maintaining API fluency.

Executes the query and returns the number of rows that were updated

Marks the WITH clause as recursive.

Adds a RETURNING clause. Requires using methods like .toList(), .toSingle(), etc. instead of .execute().

Fetches a list of values from the first column of all rows. Nullability of elements is determined by the KType: use toColumn<Int>() for non-null or toColumn<Int?>() for nullable elements.

Fetches a single value from the first column of the first row. Nullability is determined by the KType: use toField<Int>() for non-null or toField<Int?>() for nullable results.

Fetches a single value from the first column of the first row. Always returns Failure if no rows are found, regardless of nullability. Nullability only controls whether a null value in the column is allowed: use toFieldStrict<Int>() to fail on null, or toFieldStrict<Int?>() to allow null values.

Fetches a list of rows as List

Maps results to a list of objects of the given type. Requires that column names/aliases in SQL (in snake_case convention) match property names in the target class (in camelCase convention) or have a @MapKey annotation with the stored column name.

Convenient inline extension function for toListOf. Uses reified to automatically infer the target type.

Fetches a single row as Map?. Returns Success(null) if no rows.

Maps the result to a single object of the given type. Works on the same mapping principle as toListOf. Nullability is determined by the KType: use toSingleOf<User>() for non-null or toSingleOf<User?>() for nullable results.

Convenient inline extension function for toSingleOf. Uses reified to automatically infer the target type.

Fetches a single row as Map. Returns Failure if no rows.

Returns the SQL string without executing the query.

Adds a USING clause.

Defines the WHERE condition. The clause is mandatory for security reasons.

Adds a Common Table Expression (CTE) to the query.