query

fun query(sql: String, params: Array<out Any?> = emptyArray(), parameterSerializer: ParameterSerializer? = null, mapper: ResultMapper, maxRows: Int = 0): List<Row>

Uses Extended Query Protocol. Intended for DQL (SELECT). Returns a parsed list of rows (Row) immediately.


fun <R> query(sql: String, params: Array<out Any?> = emptyArray(), parameterSerializer: ParameterSerializer?, mapper: ResultMapper, maxRows: Int = 0, transform: (Row) -> R): List<R>

Uses Extended Query Protocol. Intended for DQL (SELECT). Returns a parsed list of elements using the provided transform function immediately.