First of all, I'm very new to Hibernate and I have been looking thru the various docs and examples to get a simple question answered without success.

I have a very simple requirement. I want to be able to create a SQL query using the <subselect> element (or its equalent atttibute) to map to a single POJO type (immutable and read-only). Simple, isn't it?

This query can be a bit complex in that it can involve table joins, wrapping functions around the selected columns, etc.

<hibernate-mapping package="eg">
<class name="Summary">
<subselect>
select item.name, max(bid.amount), count(*)
from item
join bid on bid.item_id = item.id
group by item.name
</subselect>
<synchronize table="item"/>
<synchronize table="bid"/>
<id name="name"/>

<property name="name" column="name"/>
<property name="amount" column="??????"/>
<property name="count" column="??????"/>
...
</class>


For the property mapping, what is the corresponding column name?

I am a Hibernate newbie myself. But if I understand your scenario, I believe all you need are aliases for your computed columns, like this: