Our application uses lots of proprietary dynamic sql for reports and such that I would like to be able to map to POJOs without too much effort. createSQLQuery can do some of this, but it's pretty cumbersome. I think the API could be simplified to dynamically map column aliases to a specified custom entity.

Typically you would use JDBC directly for this, but it would be convenient to leverage hibernates features in many cases.

Do you have any plans along these lines? I'm happy to pitch in.

Thanks,
Rob