http://jira.grails.org/browse/GRAILS-2803 concerns lack of support for sqlProjection. It was closed as a duplicate and supposedly fixed in Grails v1.2. But the "duplicate" issue concerned sqlRestriction and I do not believe sqlProjection has been implemented as of Grails v1.3.2 at least.

Are there any workarounds to use sqlProjection within a critera? For example,