gistfile1.txt

sub latest_posts ($self) {
  $self->Q->published_posts
          ->include_author
          ->latest(10)
          ->hashes->all;
}

same as  ???

select 
  post.*,
  json_agg(comments),
  json_agg(author)
  from posts post
  left join comments on comments.post_id = post.id 
  join users author on author.username = post.author_username
  where post.is_published is true
  group by post.id, author.id
  order by post.published_at  DESC
  limit 10;