The built-in JSON functionality is very powerful. txtai (https://github.com/neuml/txtai https://github.com/neuml/txtai) takes full advantage of it and stores al

The built-in JSON functionality is very powerful. txtai (https://github.com/neuml/txtai https://github.com/neuml/txtai) takes full advantage of it and stores all relational data as JSON in SQLite. The ability to build indexes on these JSON functions is important. Found this article to be a good reference: https://www.delphitools.info/2021/06/17/sqlite-as-a-no-sql-database/ https://www.delphitools.info/2021/06/17/sqlite-as-a-no-sql-d...