JSON on Sqlite works out of the box in ubuntu, but it doesn't in OpenBSD. Not sure about other environments. It supports querying, see json_extract function.

JSON on Sqlite works out of the box in ubuntu, but it doesn't in OpenBSD. Not sure about other environments. It supports querying, see json_extract function. https://www.sqlite.org/json1.html https://www.sqlite.org/json1.html I use it a lot to return JSON from normalized data, for apps to consume.