[Hibernate-issues] [Hibernate-JIRA] Created: (HHH-1912) Allow quoted aliases in HQL select clause

[Erik G (JIRA) <no...@at...>]

Allow quoted aliases in HQL select clause
-----------------------------------------

         Key: HHH-1912
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1912
     Project: Hibernate3
        Type: Improvement

  Components: query-hql  
    Versions: 3.2.0.cr3    
    Reporter: Erik G


It would be nice to have quoted identifiers in HQL select clause.

Use Case:
Using an HQL select query to generate reports. HQL is a powerful language and in many ways easier to use than SQL. When trying to use arbitrary HQL queries to generate a report and use the getReturnAliases() method on the Query to determine column-headers for a report, it would be great to have the ability to quote the aliases.

For example, take the query "select firstName, lastName from Customer c" 

if you wanted to introduce more readable aliases into the query, it would be natural to want to try 

"select firstName as `First Name`, lastName as `Last Name` from Customer c" but this does not seem to work.

I'd be happy to help with a fix if someone could point me in the right direction.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira