About SQL sort clause generation

Hibernate ORM
1 
CriteriaQuery<Object[]> cq = cb.createQuery(Object[].class);
Root<Entity> from = cq.from(Entity.class);
cq.multiselect(from.get(Entity_.field1),from.get(Entity_.field2))
       .where(
               ... predicates
        )
        .orderBy(cb.asc(from.get(Entity_.field1)));

When using Object[].class to create a CriteriaQuery with multiselect (without specifying aliases), the generated SQL ORDER BY clause appears as ORDER BY 1 (positional index) instead of the column name (e.g., id ).
Is there any configuration or alternative approach to force Hibernate to always generate ORDER BY clauses using column names (e.g., ORDER BY id ) rather than positional indexes?
THANKS

2

There is no such configuration. This is a standard SQL feature and Hibernate ORM makes use of it to reduce the size of the SQL and improve readability. If one of your select items were an expression that contains a query parameter, using the alias/ordinal reference would also be the only way to make this work properly.