Using 2.1.2 with mysql:

Query q = sess.createQuery(
"select sum(nf.charges) as charges, sum(nf.claims) as claims, count(*) as files, p.name as name "
+ "from NativeFormat as nf inner join nf.provider as p "
+ "where nf.dateCreated > :start and nf.dateCreated < :end "
+ "group by p.id, p.name");

And the resulting exception.

net.sf.hibernate.QueryException: , expected in SELECT [select sum(nf.charges) as charges, sum(nf.claims) as claims, count(*) as files, p.name as name from com.webify.hta.domain.cfnr.NativeFormat as nf
inner join nf.provider as p where nf.dateCreated > :start and nf.dateCreated < :end group by p.id, p.name]

mike

There are no "column name aliases" like "as charges" in HQL.