Currently using predicate operators in order by clause is not allowed in HQL while using functions or other expressions are allowed. This makes hard to create query like:

SELECT * FROM users ORDER BY type='VVIP' DESC, type='VIP' DESC, name ASC;

so I've been using custom MySQL function named 'eq' which just wraps '=' operator like:

SELECT * FROM users ORDER BY eq(type, 'VVIP') DESC, eq(type, 'VIP') DESC, name ASC;

It would be great if I can use predicate operators like '=' or '<' in HQL order clauses.