Understanding and Working Around Aliases in Hibernate's SQL Generation

Converting VARCHAR to Numeric in SQL using Enums and CriteriaAPI

How to Use Subselect, Group by, and Having Count with Criteria in Hibernate