Query: backup_vaults_for_backup_plan

select
  v.arn as backup_vault_arn
from
  aws_backup_vault as v,
  aws_backup_plan as p,
  jsonb_array_elements(backup_plan -> 'Rules') as r
where
  r ->> 'TargetBackupVaultName' = v.name
  and p.arn = $1;