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 []]);