RunnableQuery

Decides which session the terminals run on.

This query with terminals that return a DataResult instead of throwing, on the boundary dbResult applies - a fetch*Strict that found no row still throws.

Turns this query into a step of a TransactionPlan instead of running it. The parameters given at the step's terminal may hold TransactionValues pointing at earlier steps.

Carries registered converters into a builder's copy(), alongside whatever clauses it copies.

Runs the statement and returns how many rows it affected.

Runs the query and returns the first column of its single row as T. A nullable T gives null for a missing row or a NULL; a non-nullable one throws for either.

Runs the query and returns the first column of its single row as T.

Runs the query and returns the first column of every row as T.

As fetchField, but the query must return exactly one row rather than at most one.

Runs the query and maps its single row onto T, or null where none matched.

Runs the query and maps every row onto T.

Runs the query and maps its single row onto T, throwing where the count was anything but one.

Runs the query and returns its single row, or null where none matched.

Runs the query and returns every row.

Runs the query and returns its single row, throwing where the count was anything but one.

Runs the query and hands the first column of each row, as T, to block as forEachRow does.

Runs the query and hands the first column of each row, as T, to block as it arrives.

Runs the query and hands each row, mapped onto T, to block as it arrives, as forEachRow does.

Runs the query and hands each row, mapped onto T, to block as it arrives.

Runs the query and hands each row to block as it arrives, so a result too large to hold is streamed. block runs while the result is still being read, and a query from inside it is refused with CONNECTION_BUSY.

Runs the query and hands each row to block as it arrives, in batches of fetchSize.

The driver query every terminal runs, carrying this query's own converters.

Renders the SQL. Called once per terminal call, so a builder may put off assembling it until here.

Registers a ParameterConverter for this query alone, on the terms of registerResultConverter.

Registers a ResultConverter for this query alone, consulted ahead of the session's. A later registration here wins over an earlier one.

Renders the SQL this query would send. A query never carries parameters, so its @name placeholders survive embedding it in a WITH, a subquery or a UNION, and are bound by whoever runs the outer statement. Not cached: a builder walks its clauses again on every call.