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

I use it a lot to return JSON from normalized data, for apps to consume.