first method
Execute the query and get the first result.
Implementation
Future<Map<String, dynamic>> first() async {
_setStatement(Operator.get);
_setLimit(1);
_buildSql();
var results = await db.select(_sql);
if (results.isNotEmpty) {
return results[0];
} else {
return Map.of({});
}
}