Postgres has JSON operators you can put into expressions, including WHERE clauses. You can write queries like:

SELECT item_details->‘manufacturer’->‘location’ FROM inventory WHERE item_details->‘material’ = “concrete”;

Storing data in JSON columns has other trade-offs, though.