delete method
Executes a DELETE query with a required WHERE clause.
Deletes rows in the table
that match the where
conditions.
Implementation
@override
Future<DbResult> delete(
String table, {
required Map<String, dynamic> where,
}) async {
final conditions = where.keys.map((k) => '$k = @$k').join(' AND ');
final query = 'DELETE FROM $table WHERE $conditions;';
return rawQuery(query, values: where);
}