Query: logging_source_s3_buckets_for_s3_bucket

select
  lb.arn as bucket_arn
from
  aws_s3_bucket as lb,
  aws_s3_bucket as b
where
  b.arn = $1
  and lb.logging ->> 'TargetBucket' = b.name;