Understanding and Working Around Aliases in Hibernate's SQL Generation

Updating Column String Value Based on Multiple Criteria in Other Columns Using Boolean Masks and Chained Comparisons