select abstract method
Prepares the sql
statement and runs it with the provided parameters
,
returning all rows returned by the statement.
For the types supported in parameters
, see StatementParameters.
The statement doesn't have to be an SQL SELECT
statement. Any statement
that returns rows (e.g. writes with a RETURNING
clause) can be executed
with select
.
This method fully runs the statement, buffers all rows and then returns
them at once in a ResultSet. This package also supports stepping through
a result set row-by-row. To do that, first prepare the statement with
prepare
and then call CommonPreparedStatement.iterateWith
.
Implementation
ResultSet select(String sql, [List<Object?> parameters = const []]);