Query: kms_keys_for_sqs_queue

select
  k.arn as key_arn
from
  aws_sqs_queue as q,
  aws_kms_key as k,
  jsonb_array_elements(aliases) as a
where
  a ->> 'AliasName' = q.kms_master_key_id
  and k.region = q.region
  and k.account_id = q.account_id
  and q.queue_arn = $1;