Query: open_merge_request_table

select
  p.full_path as "Project",
  m.title as "Merge Request",
  now() :: date - m.created_at :: date as "Age in Days",
  now() :: date - m.updated_at :: date as "Days Since Last Update",
  author_username as "Author",
  m.web_url,
  p.web_url as project_url
from
  gitlab_my_project p
  join gitlab_merge_request m on m.project_id = p.id
where
  m.state = 'opened'
order by
  "Age in Days" desc;