first method
Executes a SELECT query and returns only the first matching row.
Implementation
Future<Map<String, dynamic>?> first() async {
final results = await _executor.query('${_buildSelect()} LIMIT 1', _snapshotParams());
return results.rows.isNotEmpty ? results.rows.first : null;
}