I am using Expo.SQLite on Android.
SELECT doc FROM example_table ORDER BY json_extract(doc, '$.a.b.c') DESC
no such function: json_extract (code 1): , while compiling
The same code works on iPhone with no issues.
SELECT sqlite_version() // "3.19.4"
How can I enable the JSON1 extension for Android?
Could https://github.com/requery/sqlite-android be integrated into Expo?