According to the docs here: http://grails.codehaus.org/Hibernate+Criteria+Builder we are supposed to be able to use sqlProjection() to add an arbitrary SQL-based projection as specifed here: http://www.hibernate.org/hib_docs/v3/api/org/hibernate/criterion/Projections.html
This doesn't seem to be implemented.
I am trying a work around using this method:
but to no avail. I get the following error:
Any idea when it will be possible to add such Projections?