anchor.diff:   List<Tuple> fetch = query.fetch();
   ----
   
  -==== Named window functions
  +=== Named window functions
   
   [source,java]
   ----
  
positive.code: ----
  QRecursiveEntity recursiveEntity = new QRecursiveEntity("t");
  
  List<RecursiveEntity> fetch = new BlazeJPAQuery<>(entityManager, cbf)
      .select(recursiveEntity)
      .from(select(recursiveEntity)
          .from(recursiveEntity)
          .where(recursiveEntity.parent.name.eq("root1"))
          .orderBy(recursiveEntity.name.asc())
          .limit(1L), recursiveEntity)
      .fetch();
  ----
  
negative.code:     .fetch();
  ----
  
  === Recursive CTEs
  
  Set operations are also allowed in CTEs, and through set operations it is also possible to write recursive CTEs.
  
  