first method
Implementation
Future first({int? paginate}) async {
Database db = await database;
if (paginate != null) {
limit(paginate);
}
List<Map<String, Object?>> result = await db.rawQuery(_query, _bindings);
if (result.isEmpty) return null;
return fromMap(result.first);
}