I'm pretty sure one can create indices based on JSON expressions (see, for example, http://sqlite.1065341.n5.nabble.com/Partial-indexes-on-JSON-properties-td916

I'm pretty sure one can create indices based on JSON expressions (see, for example, http://sqlite.1065341.n5.nabble.com/Partial-indexes-on-JSON-properties-td91662.html http://sqlite.1065341.n5.nabble.com/Partial-indexes-on-JSON-...). I don't know how it compares to Postgres' JSON support.