'Is there operator AS (like in sql) in grails createria?

I want to rewrite this query to grails createria:

 String query = "SELECT * FROM Cars as ca WHERE ca.body = :bodies AND car.modelYeas > :data AND " +
                    "IF (ca.brend = 'Opel', " +
                        "exists (select Hood from Parts as p where p.number = ca.number AND ..., " +
                        "select Hood from Parts as p where p.wheel = ca.wheel AND ..., " +
                    ")"

hibernate grails

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Is there operator AS (like in sql) in grails createria?

Sources

Related Questions