get method

List<Map<String, dynamic>> get()

Execute the query and return results

Implementation

List<Map<String, dynamic>> get() {
  final columns = _columns.isEmpty ? '*' : _columns.join(', ');
  String sql = 'SELECT $columns FROM $_table $_whereClause';
  final args = <dynamic>[..._whereArgs];

  // Add LIMIT and OFFSET directly to SQL, not as parameters
  if (_limit != null && _offset != null) {
    sql += ' LIMIT $_limit OFFSET $_offset';
  } else if (_limit != null) {
    sql += ' LIMIT $_limit';
  } else if (_offset != null) {
    // OFFSET without LIMIT - use -1 for no limit
    sql += ' LIMIT -1 OFFSET $_offset';
  }

  final results = _db.query(sql, args);
  return results;
}