SQLite has JSON support via the json1 extension[1]. IIRC it's bundled into SQLite by default in recent releases. As for arrays, you're SOL unless you use JSON a

SQLite has JSON support via the json1 extension[1]. IIRC it's bundled into SQLite by default in recent releases. As for arrays, you're SOL unless you use JSON arrays. :) [1]: https://www.sqlite.org/json1.html https://www.sqlite.org/json1.html