Using SQL/JSON Path Queries

SELECT * FROM jsonb_path_query(
  '{"users":[{"id":1},{"id":2}]}',
  '$.users[*].id'
);

SELECT jsonb_path_query_array(payload, '$.items[*].sku') FROM events;

SELECT jsonb_path_query_first(payload, '$.user.id') FROM events;

SELECT * FROM events WHERE jsonb_path_exists(payload, '$.user_id ? (@ > 100)');

SELECT * FROM events WHERE jsonb_path_match(payload, '$.active == true');

SELECT jsonb_path_query(payload, 'strict $.user.email') FROM events;
SELECT jsonb_path_query(payload, 'lax $.users[*].email');

SELECT jsonb_path_query(payload, '$.items[*] ? (@.price > 100)') FROM events;

SELECT jsonb_path_query(payload, '$.items[*].price * $.qty');

SELECT jsonb_path_query(payload, '$.items[*] ? (@.price > $min)',
       '{"min": 100}'::jsonb) FROM events;