Query: kms_key_aliases

select
  p ->> 'AliasArn' as "Alias Arn",
  p ->> 'AliasName' as "Alias Name",
  p ->> 'LastUpdatedDate' as "Last Updated Date",
  p ->> 'TargetKeyId' as "Target Key ID"
from
  aws_kms_key,
  jsonb_array_elements(aliases) as p
where
  arn = $1
  and region = split_part($1, ':', 4)
  and account_id = split_part($1, ':', 5);