Query: vpc_subnets_for_codebuild_project

select
  trim((s::text), '""') as vpc_subnet_id
from
  aws_codebuild_project,
  jsonb_array_elements( vpc_config -> 'Subnets') as s
where
  arn = $1
  and account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4);