Query: default_branch_protection_table

select
  name_with_owner as "Repository",
  (default_branch_ref ->> 'name') as "Default Branch",
  case
    when (default_branch_ref -> 'branch_protection_rule') is null then 'Unknown - manual check required'
    else 'Protected'
  end as "Protection Status",
  (default_branch_ref -> 'branch_protection_rule' ->> 'restricts_pushes')::bool as "Restricts Pushes",
  (default_branch_ref -> 'branch_protection_rule' ->> 'allows_force_pushes')::bool as "Allows Force Pushes",
  (default_branch_ref -> 'branch_protection_rule' ->> 'allows_deletions')::bool as "Allows Deletions",
  (default_branch_ref -> 'branch_protection_rule' ->> 'requires_approving_reviews')::bool as "Requires Approvals",
  (default_branch_ref -> 'branch_protection_rule' ->> 'requires_conversation_resolution')::bool as "Requires Conversation Resolution",
  (default_branch_ref -> 'branch_protection_rule' ->> 'requires_commit_signatures')::bool as "Requires Signed Commits",
  (default_branch_ref -> 'branch_protection_rule' ->> 'requires_linear_history')::bool as "Requires Linear History",
  (default_branch_ref -> 'branch_protection_rule' ->> 'is_admin_enforced')::bool as "Applies to Admins",
  url
from
  github_my_repository
order by
  name_with_owner;