MySQL nor PostgreSQL does not support aliases in WHERE clauses: https://stackoverflow.com/questions/942571/using-column-alias-in-where-clause-of-mysql-query-produces-an-error
Therefore we can't use the java bean property names when constructing the WHERE clause, but we must use the actual column names.