count method
Executes a COUNT query and returns the total number of matching rows.
Implementation
Future<int> count() async {
final results = await _executor.query(_buildSelect(overrideColumns: ['COUNT(*) as count']), _snapshotParams());
final result = results.rows.isNotEmpty ? results.rows.first : null;
return result != null ? int.parse(result['count'].toString()) : 0;
}