Query: key_vault_soft_delete_status

select
  'Soft Delete' as label,
  case
    when soft_delete_enabled then 'Enabled'
    else 'Disabled'
  end as value,
  case
    when soft_delete_enabled then 'ok'
    else 'alert'
  end as type
from
  azure_key_vault
where
  lower(id) = $1;