Query: vpc_vpcs_for_sqs_queue

select
  vpc_id
from
  aws_vpc_endpoint,
  jsonb_array_elements(policy_std -> 'Statement') as s,
  jsonb_array_elements_text(s -> 'Resource') as r
where
  r = $1
  and account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4)