Issue description

Pull request 10273 moved PRAGMA requests to the run method in v 0.3.20, and they now fail

Expected Behavior

PRAGMA requests should use the query method in Capacitor sqlite, so they execute correctly. #10273, which was merged in version 0.3.20, moved it to the run method.

The owner of Capacitor sqlite repo has verified this in capacitor-community/sqlite#512. Also, sqlite, sqlite-abstract and better-sqlite3 all execute PRAGMA requests under the query method.

Actual Behavior

Executing PRAGMA table_info(...) in v 0.3.20 fails with a result 100 error. See #10273 (comment) for a screenshot.

Steps to reproduce

Execute "PRAGMA table_info('user')"

My Environment

Additional Context

No response

Relevant Database Driver(s)

• aurora-mysql
• aurora-postgres
• better-sqlite3
• cockroachdb
• cordova
• expo
• mongodb
• mysql
• nativescript
• oracle
• postgres
• react-native
• sap
• spanner
• sqlite
• sqlite-abstract
• sqljs
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

Yes, I have the time, and I know how to start.