Another one is that JPQL requires that an item in the order by column must also be defined in the select clause. Generally that is a good idea (db portability), but not all dbs require that and so HQL does not require it.