Is there any chance to mix hql query with dynamically built Criteria? Sometimes I need to build filter on the fly from user-input but for a bit more difficult query than just simple one-object criteria.
HQL would work for me as a fixed filter and user can further constrain it with criteria expressions.