Support pragma statements that return results

[AlecKazakova]

https://www.sqlite.org/pragma.html

[ScottPierce]

This would be nice.

[melnikovdv]

Is it safe to do pragma requests this way until the issue is complete?

val driver = JdbcSqliteDriver("jdbc:sqlite:temp.db")
driver.execute(null, "PRAGMA user_version = 2;", 0, null)
val sqlCursor = driver.executeQuery(null, "PRAGMA user_version;", 0, null)
val userVersion = sqlCursor.getLong(0)!!

And as issue title is about statements that return results how to execute pragma statements that don't return results?

[treitter]

I'd also like to be able to fetch PRAGMA user_version via labeled SQL statement like:

getVersion:
PRAGMA user_version;

I'd already been using this PRAGMA value in a SQLite DB that I'm migrating to use from SQLDelight.