Query: storage_account_virtual_network_rules

select
  vnr ->> 'action' as "Action",
  vnr ->> 'id' as "ID",
  vnr ->> 'state' as "State"
from
  azure_storage_account,
  jsonb_array_elements(virtual_network_rules) as vnr
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);