rawQuery method

@override Future<DbResult> rawQuery(String query, { Map<String, dynamic>? values, })

Executes a raw SQL query and returns the result.

• query: The SQL query to execute.
• values: Optional named parameters for substitution (e.g., @name).

Implementation

@override
Future<DbResult> rawQuery(
  String query, {
  Map<String, dynamic>? values,
}) async {
  final stopwatch = Stopwatch()..start();
  final result = await _pool.execute(query, values ?? {});
  return DbResult(
    rows: result.rows.map((row) => row.assoc()).toList(),
    affectedRows: result.affectedRows.toInt(),
    insertId: result.lastInsertID,
    executionTime: stopwatch.elapsed,
  );
}