I have defined an sql query and defined the hibernate return classes using the <sql-query> mapping tag. However, I wonder if it is possible to get some other value from the query that is not actually a class? I.e. some other string or integer column.

<sql-query>
<return alias="alias1" class="class1">
<return alias="alias2" class="class2">
select {alias1.*}, {alias2.*}, other.some_value
from table1 alias1, table2 alias2, table3 other
</sql-query>

Thanks,
Thomas

No, this is currently not possible.

Actually it is useful in very specific cases since the best framework for scalar returns from a SQL query is... JDBC. The only combination of an entity and a scalar result is revelent (provided that you couldn't have used HQL).