Query: codepipeline_pipeline_stages

select
  s ->> 'Name' as "Name",
  a as "Actions"
from
  aws_codepipeline_pipeline,
  jsonb_array_elements(stages) as s,
  jsonb_array_elements(s -> 'Actions') as a
where
  arn = $1
  and region = split_part($1, ':', 4)
  and account_id = split_part($1, ':', 5);