getOptional method
Execute a read-only (SELECT) query and return a single optional result.
Implementation
@override
Future<Row?> getOptional(String sql,
[List<Object?> parameters = const []]) async {
final rows = await getAll(sql, parameters);
return rows.isEmpty ? null : rows.first;
}