query method
Executes a SQL query and returns a DataFrame
Implementation
@override
Future<DataFrame> query(String sql, {List<dynamic>? parameters}) async {
if (!_isConnected || _connection == null) {
await connect();
}
try {
final result = await _connection!.execute(sql);
return _mysqlResultToDataFrame(result);
} catch (e) {
throw DatabaseQueryError('MySQL query failed: $e');
}
}