rawQuery method
Executes a raw SQL query using named parameter substitution.
Returns a DbResult with the rows, affected row count, and insert ID.
Implementation
@override
Future<DbResult> rawQuery(
String query, {
Map<String, dynamic>? values,
}) async {
final result = await _connection.execute(query, values ?? {});
return DbResult(
rows: result.rows.map((row) => row.assoc()).toList(),
affectedRows: result.affectedRows.toInt(),
insertId: result.lastInsertID,
);
}