Map<Integer, Group> results = CollQueryFactory.from(post, posts).from(comment, comments)
.where(comment.post.id.eq(post.id))
.transform(groupBy(post.id).as(post.name, set(comment.id), list(comment.text)));
Group group = results.get(1);
Object[] array = group.toArray();
assertEquals(toInt(1), array[0]);
assertEquals("Post 1", array[1]);
assertEquals(toSet(1), array[2]);
assertEquals(Arrays.asList("Comment 1"), array[3]);
}