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