Table: github_my_repository

select
  name,
  owner_login,
  name_with_owner
from
  github_my_repository
order by
  name_with_owner;

select
  name,
  owner_login,
  primary_language ->> 'name' as language,
  fork_count,
  stargazer_count,
  subscribers_count,
  watchers_total_count,
  updated_at as last_updated,
  description
from
  github_my_repository;

select
  name,
  is_private,
  visibility,
  owner_login
from
  github_my_repository
where
  not is_private;

select
  name,
  is_private,
  visibility
from
  github_my_repository
where
  visibility = 'PUBLIC';

select
  r.name_with_owner as repository_full_name,
  c.user_login,
  c.permission
from
  github_my_repository r,
  github_repository_collaborator c
where
  r.name_with_owner = c.repository_full_name;

select
  r.name_with_owner as repository_full_name,
  c.user_login,
  c.permission
from
  github_my_repository r,
  github_repository_collaborator c
where
  r.name_with_owner = c.repository_full_name
  and permission in ('ADMIN', 'MAINTAIN');

select
  name as repository,
  hook
from
  github_my_repository,
  jsonb_array_elements(hooks) as hook
where
  hook -> 'config' ->> 'insecure_ssl' = '1'
  or hook -> 'config' ->> 'secret' is null
  or hook -> 'config' ->> 'url' not like '%https:%';