如何在Postgres中过滤JSON数组

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    data JSONB
);

INSERT INTO users (data) VALUES
    ('{"skills": ["JavaScript", "Python", "SQL"]}'),
    ('{"skills": ["Java", "C++", "HTML"]}'),
    ('{"skills": ["Ruby", "PHP", "CSS"]}');

-- 过滤出具有"JavaScript"技能的用户
SELECT *
FROM users
WHERE data->'skills' @> '["JavaScript"]';

-- 过滤出具有"Python"或"SQL"技能的用户
SELECT *
FROM users
WHERE data->'skills' ?| array['Python', 'SQL'];

-- 过滤出具有"Java"和"C++"技能的用户
SELECT *
FROM users
WHERE data->'skills' @> '["Java", "C++"]';