A modern programming language that makes developers happier.

kotlinlang

While it's not explicitly mentioned in the docs, but is <https://github.com/requery/sqlite-android|sqlite-android from Requery> the preferred method to get a json1 compatible sqlite version in SQLDelight (on Android)?

Looks like using: `dialect = "app.cash.sqldelight:sqlite-3-35-dialect:2.0.0-alpha02"`
With: `implementation 'com.github.requery:sqlite-android:3.36.0'`
and this is working quite well:
```val driver = AndroidSqliteDriver(
            schema = MyDatabase.Schema,
            context = this,
            name = "test.db", 
            factory = RequerySQLiteOpenHelperFactory()
        )```

you'll have to add the json dialect extension too: <https://github.com/cashapp/sqldelight/blob/master/sqldelight-gradle-plugin/src/test/integration-sqlite-json/build.gradle#L19>

that will enable you to use the json stuff in `.sq` files

Screen Shot 2022-05-09 at 3.54.44 PM.png

```{
    ....
    implementation 'com.github.requery:sqlite-android:3.36.0'
    implementation 'app.cash.sqldelight:android-driver:2.0.0-alpha02'
    // implementation 'app.cash.sqldelight:sqlite-json-module:2.0.0-alpha02' // Doesn't seem to be needed?
}

sqldelight {
    MyDatabase {
        packageName = "com.example.hellojson"
        dialect = "app.cash.sqldelight:sqlite-3-35-dialect:2.0.0-alpha02"
    }
}```
It seems like i dont need to explicitly include that json module (unless i'm including it in the wrong way)? Without it, i can still use json1 (`json_extract`) in the app when implemented as in the screenshot above :thinking_face:

it gets you other stuff like `json_each` or exposing json function results in projections