@Test
  void orderBy() {
    final ImmutableQuery query = Query.of(Person.class);
    check(generate(query.withCollations((Collation) person.fullName.asc())))
            .is("SELECT * FROM /myRegion ORDER BY fullName");

    check(generate(query.withCollations((Collation) person.age.desc(), (Collation) person.fullName.asc())))
            .is("SELECT * FROM /myRegion ORDER BY age DESC, fullName ASC");

    check(generate(query.withCollations((Collation) person.fullName.desc()).withLimit(1).withOffset(10)))
            .is("SELECT * FROM /myRegion ORDER BY fullName DESC LIMIT 1 OFFSET 10");
  }
Check generated OQL out of {@link Query}
criteria/geode/test/org/immutables/criteria/geode/OqlGeneratorTest.java