.list(e.id, e.firstname, e.superiorId),
sq().from(e, sub).where(e.superiorId.eq(sub.get(e.id)))
.list(e.id, e.firstname, e.superiorId)))
.from(sub);
QueryMetadata md = query.getMetadata();
md.addProjection(Wildcard.all);
SQLSerializer serializer = new SQLSerializer(Configuration.DEFAULT);
serializer.serialize(md, false);
assertEquals("with recursive sub (ID, FIRSTNAME, SUPERIOR_ID) as ((select EMPLOYEE.ID, EMPLOYEE.FIRSTNAME, EMPLOYEE.SUPERIOR_ID\n" +
"from EMPLOYEE EMPLOYEE\n" +
"where EMPLOYEE.FIRSTNAME = ?)\n" +