Query: vpc_nat_gateways_for_vpc_eip

select
  g.arn as gateway_arn
from
  aws_vpc_eip as e,
  aws_vpc_nat_gateway as g,
  jsonb_array_elements(nat_gateway_addresses) as a
where
  a ->> 'NetworkInterfaceId' = e.network_interface_id
  and e.arn = $1;