Postgres JSON Querying

-- Extract field
SELECT metadata->>"title" AS title FROM modules;

-- Filter by nested value
SELECT * FROM modules WHERE metadata @> '{"is_featured": true}';

-- Aggregate a JSONB array field
SELECT jsonb_array_elements(tips) AS tip FROM modules WHERE id = 1;

-- Update a single key without replacing the whole document
UPDATE modules
SET metadata = metadata || '{"views": 100}'
WHERE id = 1;