Postgres中对Jsonb多级对象进行查询
SELECT
e
FROM
scene_actor_template_typhoon_record
CROSS JOIN LATERAL jsonb_array_elements ( points -> 'points' ) AS e
WHERE
points :: jsonb ->> 'name' = '雷伊'
AND e :: jsonb ->> 'time' > '2021-12-13T14:00:00'
AND e :: jsonb ->> 'time' <= '2021-12-14T14:00:00'