I've searched up and down trying to figure out how to load the SQLite json1 extension in Flutter with the Sqflite plugin version 2.0.0+3, but unsuccessful so far. I want to use json1 methods eg. json_object() and json_group_array() as described in this link: https://sqlite.org/json1.html#jobj. My Flutter version is 2.0.6. Sqlite version is 3.28.0.
Someone else mentioned that "With sqflite version 1.2.1, I'm able to load the json function." in this link: Loading JSON1 extension with flutter sqflite but I could not find any additional info.
Appreciate any input, thanks!