FetchSpec
Specifies how to execute the built SQL and retrieve the results.
Each terminal operation (singleMap, single, list, sequence, rowsUpdated, generatedValues, ...) executes the statement when invoked.
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.
Sets the maximum number of rows to return from this query.
Sets the query timeout (in seconds) for this query.
Executes the statement (typically INSERT, UPDATE, or DELETE) and returns the number of affected rows.
Executes the query and returns each row converted to returnType, as a sequence that streams rows without accumulating them all in memory.
Executes the query and returns each row converted to T, as a sequence that streams rows without accumulating them all in memory.
Executes the query and returns each row as a map keyed by column name, as a sequence that streams rows without accumulating them all in memory.
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.