Query: kms_keys_for_codepipeline_pipeline

select
  k.arn as kms_key_arn
from
  aws_codepipeline_pipeline as p,
  aws_kms_key as k,
  jsonb_array_elements(aliases) as a
where
  a ->> 'AliasArn' = p.encryption_key ->> 'Id'
  and p.arn = $1;