I'm not sure I understand the problem here. If I understand correctly you have a property mapped to a formula and reference that property in a HQL CASE statement. Hibernate renders the formula into the SQL CASE statement and then the database just does not like that. Is that accurate?