I have seen this issue being posted 'n' number of times, but dont have a clear neat way of
resolving it.
The problem is using hibernate + JPA , where if i use alaises, hibernate, fails to read the columns,
And the reason i am using aliases because, i have the same column name in the tables i doin a join opeation.

I have seen solution involving SQLResultSetMapping, but is it the only way to resolve it ??