List<Book> books
= new CriteriaDefinition<>(session, Book.class) {
public void define() {
var book = from(Book.class);
where(like(book.get(Book_.title), "%Hibernate%"));
orderBy(desc(book.get(Book_.publicationDate)), asc(book.get(Book_.isbn)));
book.fetch(Book_.authors);
}
}
.createSelectionQuery()
.setMaxResults(10)
.getResultList();