[tyre]

and json path is supported in Postgres as a way to query json documents. It’s surprisingly full featured!