with orders(id, tourists) as (values
(1, '[{"orders_tourist_id":1, "tourist_name": "Василий Петрович"},
        {"orders_tourist_id":2, "tourist_name": "Евгений Максимович"}]'::json),
(2, '[{"orders_tourist_id":1, "tourist_name": "Аркадий Аркадевич"},
        {"orders_tourist_id":2, "tourist_name": "Иван Кузьмич"}]'::json)) 

select * from orders,
        lateral (select array_agg(x->>'tourist_name') from json_array_elements(tourists) as x) as tourists(name)
        where 'Василий Петрович' = any(tourists.name);