Is it possible to set up a named query to simply return an array of object[]? I want to do something like:

<sql-query name="MyQuery">
<![CDATA[
select c.Name, sum(o.Amount) from Customer c
join Order o on c.ID = o.ID
]]>
</sql-query>

And get back basically a record set in the form of an array of type object[] (like this hql does:

select mother, offspr, mate.Name
from Eg.DomesticCat as mother
inner join mother.Mate as mate
left outer join mother.Kittens as offspr
)

However, it looks like with my sql-query I always have to specify an entity in the:

<return alias="customer" class="Customer"/>