RawQueryBuilder
Defines the public API for passing a complete raw SQL query.
// Call a PostgreSQL function directly
dataAccess.rawQuery("SELECT * FROM calculate_tribute(@province, @year)")
.toField<Int>("province" to "Aegyptus", "year" to 44)Functions
Converts this builder to a StepBuilderMethods for lazy execution within a TransactionPlan.
Switches the builder to streaming mode, optimal for large datasets.
Switches the builder to asynchronous mode. Requires providing a CoroutineScope in which callback will be launched.
Creates and returns a deep copy of this builder. Useful for creating query variants from a shared base without modifying the original.
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.
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.
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