sequence

Executes the query and returns each row converted to returnType, as a sequence that streams rows without accumulating them all in memory.

The returned sequence is backed by an open JDBC ResultSet; iterate it within an active transaction. It is closed automatically when fully iterated or when fetching the next element throws; exceptions thrown by your own processing code do not close it. Unless you fully iterate the sequence, close it explicitly (e.g., with use). It can be iterated only once. See CloseableSequence.

When fetching a simple scalar type from a single-column query, SQL NULL is kept as a null element even though this cannot be expressed in the CloseableSequence<T> type.