insert method
Executes an INSERT query and returns the result.
Automatically formats the columns and values as placeholders for parameterized execution.
Implementation
@override
Future<DbResult> insert(String table, Map<String, dynamic> data) async {
final columns = data.keys.join(', ');
final values = data.keys.map((k) => '@$k').join(', ');
final query = 'INSERT INTO $table ($columns) VALUES ($values);';
return rawQuery(query, values: data);
}