Query: network_firewall_unrestricted_outbound_rules

with outbound_fw as (
  select
    id
  from
    digitalocean_firewall,
    jsonb_array_elements(outbound_rules) as i
  where
    i -> 'destinations' -> 'addresses' = '["0.0.0.0/0","::/0"]'
    and i ->> 'protocol' <> 'icmp'
  group by id
)
select
  'Outbound (Excludes ICMP)' as label,
  case when o.id is null then 'Restricted' else 'Unrestricted' end as value,
   case when o.id is null then 'ok' else 'alert' end as type
  from
    digitalocean_firewall as d
    left join outbound_fw as o on d.id = o.id
  where
    d.urn = $1;