select myField, 'foo' as MyField2 from MyTable;

How can I do that in HQL?

I tried different things such as:
select o.field, 'foo' as foo from MyClass o
select o.field, "foo" as foo from MyClass o
select o.field, new java.lang.String("foo") as foo from MyClass o

but all I get is QueryException "undefined alias" on 'foo'.

Any ideas?

Thank you in advance!
Felipe

It's not possible to use constants in HQL queries.