Query: sql_server_virtual_network_rules

select
  r ->> 'name' as "Name",
  r -> 'properties' ->> 'ignoreMissingVnetServiceEndpoint' as "Ignore Missing VNet Service Endpoint",
  r -> 'properties' ->>  'virtualNetworkSubnetId' as "Virtual Network Subnet ID",
  r ->> 'id' as "ID"
from
  azure_sql_server,
  jsonb_array_elements(virtual_network_rules) as r
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);