query method

List<Map<String, dynamic>> query(
  1. String sql,
  2. List args, {
  3. int? limit,
  4. int? offset,
})

Execute a query

Implementation

List<Map<String, dynamic>> query(
  String sql,
  List<dynamic> args, {
  int? limit,
  int? offset,
}) {
  // Add LIMIT and OFFSET if specified
  String finalSql = sql;
  if (offset != null && limit != null) {
    finalSql += ' LIMIT $limit OFFSET $offset';
  } else if (limit != null) {
    finalSql += ' LIMIT $limit';
  }

  final ResultSet result = _database.select(finalSql, args);
  // Row already implements Map<String, dynamic>
  return result.map((row) => Map<String, dynamic>.from(row)).toList();
}