queryRaw method

  1. @override
Future<List<Map<String, Object?>>> queryRaw(
  1. String sql, [
  2. List<Object?> params = const []
])
inherited

Escape hatch for raw read queries (introspection, ad-hoc SQL). Each row is a column-name -> value map.

Implementation

@override
Future<List<Map<String, Object?>>> queryRaw(
  String sql, [
  List<Object?> params = const [],
]) async {
  final result = params.isEmpty
      ? await _session.execute(sql, queryMode: pg.QueryMode.simple)
      : await _session.execute(sql, parameters: params);
  return [for (final row in result) row.toColumnMap()];
}