Query: open_issue_table

select
  '#' || number || ' ' || title as "Issue",
  repository_full_name as "Repository",
  now() :: date - i.created_at :: date as "Age in Days",
  now() :: date - i.updated_at :: date as "Days Since Last Update",
  author ->> 'login' as "Author",
  author ->> 'url' as "author_url",
  case
    when author_association = 'NONE' then 'External'
    else initcap(author_association)
  end as "Author Association",
  i.url,
  r.url as repo_url
from
  github_my_repository r
  join github_issue i on i.repository_full_name = r.name_with_owner
where
  i.state = 'OPEN'
order by
  "Age in Days" desc;