pgJQ: Use jq in Postgres The pgJQ extension 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. SELECT jq('[{"bar": "baz", "balance": 7.77, "active":false}]'::jsonb, '.[0].bar'); Usage Filters You can run basic filters: SELECT jq('[{"bar": "baz", "balance": 7.77, "active":false}...