Но установка Postgres очень большая...
select data ->> 'region' as region
from some_table
cross join lateral jsonb_array_elements(some_jsonb_field) as t(data)
where data ->> 'addressType' = 'юридический';INSERT INTO Users(id, username, first_name, last_name)
VALUES ($1, $2, $3, $4)
ON CONFLICT
DO UPDATE SET
username=EXCLUDED.username
RETURNING confirm