FetchSpec
Specifies how to execute the built SQL and retrieve the results.
Each terminal operation (singleMap, single, list, rowsUpdated, generatedValues, ...) executes the statement when invoked, except flowMap and flow, which execute it when the returned Flow is collected.
Rows are mapped to the specified type as follows: simple scalar types (numbers, strings, date/time types, ...) are read from the first column of the row, while other types (e.g. data classes) are mapped by matching column names to constructor parameters.
Functions
Sets the fetch size (the number of rows fetched from the database at a time) to use when executing this query.
Executes the statement and returns one row of values generated on the database side, such as an auto-increment ID. The map keys and value types are those reported by the configured driver and may differ from the requested column names.
Executes the statement (typically INSERT, UPDATE, or DELETE) and returns the number of affected rows.
Executes the query and returns at most one row as a map keyed by column name, or null if the query returns no rows.
Executes the query and returns at most one row converted to returnType, or null if the query returns no rows.
Executes the query and returns at most one row converted to T, or null if the query returns no rows.