I am using Expo.SQLite on Android.
SELECT doc FROM example_table ORDER BY json_extract(doc, '$.a.b.c') DESC
returns
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?
If its not possible can you add it as a feature request? Considering SQLite is interacting with Javascript, JSON support seems very useful.
Could https://github.com/requery/sqlite-android be integrated into Expo?