Query: codecommit_repositories_for_codebuild_project

select
  distinct r.arn as codecommit_repository_arn
from
  aws_codebuild_project as p
  left join aws_codecommit_repository as r on r.clone_url_http in (
    with code_sources as (
      select
        source,
        secondary_sources
      from
        aws_codebuild_project
      where
        arn = $1
    )
    select
      source ->> 'Location' as "Location"
    from
      code_sources
    union all
    select
      s ->> 'Location' as "Location"
    from
      code_sources,
      jsonb_array_elements(secondary_sources) as s
  )
where
  r.arn is not null
  and p.arn = $1;