anchor.diff:   List<Tuple> fetch = query.fetch();
   ----
   
  -==== Common Table Expressions
  +=== Common Table Expressions
   
   First declare your CTE entity:
   
  
positive.code: 
  [source,java]
  ----
  QAuthor = QAuthor.author;
  QBook book = QBook.book;
  
  Map<Author, List<Book>> booksByAuthor = new BlazeJPAQuery<>(entityManager, criteriaBuilderFactory)
  
negative.code: ----
  QRecursiveEntity recursiveEntity = new QRecursiveEntity("t");
  
  List<Author> fetch = new BlazeJPAQuery<>(entityManager, cbf)
      .select(author)
      .from(select(author)
          .from(author)
          .orderBy(author.name.asc())
          .limit(1L), recursiveEntity)
      .fetch();
  ----
  