I should convert an existing API (which is already in product use) to use Hibernate instead of plain SQL in the code (quite ugly!!). At the moment the API is implemented so that it retuns RowSetDynaClasses as the query results.

I was wondering if there's any way to implement this using Hibernate? I tried to read the documentation but couldn't find anything useful there. Am I just banging my head to the wall in vain, or should I think about some other approach. What do you think?

Thanks.