Query: lambda_function_public_access_table

select
  f.name as "Name",
  case
    when
    f.policy_std -> 'Statement' ->> 'Effect' = 'Allow'
    and (f.policy_std -> 'Statement' ->> 'Prinipal' = '*'
    or ( f.policy_std -> 'Principal' -> 'AWS' ) :: text = '*')
    then 'Public' else 'Private' end as "Public/Private",
  a.title as "Account",
  f.account_id as "Account ID",
  f.region as "Region",
  f.arn as "ARN"
from
  aws_lambda_function as f,
  aws_account as a
where
  f.account_id = a.account_id
order by
  f.name;