PgJQ: Use Jq in Postgres SQL
github.com
github.com
pgJQ embeds the standard jq compiler and brings the much-loved jq lang to Postgres.
It adds a jqprog data type to express jq programs and a jq(jsonb, jqprog) function to execute them on jsonb objects. It works seamlessly with standard jsonb functions, operators, and jsonpath.