How could I execute pragmas (such as for WAL mode)...

# squarelibraries

[krzysztof]

How could I execute pragmas (such as for WAL mode) using delight? I keep getting Queries can be performed using SQLiteDatabase query or rawQuery methods only from Android driver, either if I run is as labeled statement or just type it in my .sq schema

[krzysztof]

Native driver works fine

[krzysztof]

Just found a workaround for it:

val driver = AndroidSqliteDriver(StorageDB.Schema, ctx, dbName)
        driver.executeQuery(null, "PRAGMA journal_mode=WAL;", 0).next()

This does not crash and executes query correctly. Still not quite sure why it crashes when using execute , but SO search told me that it’s due journal_mode pragma returning a value