Indeed. The current crop of lightweight semi-ORMs (MyBatis, Ebean, ORMLite, etc) are built around that use case: let programmers write SQL, but automate the conversion of result sets to objects.

You can also do this in standard JPA, to some extent, using constructor expressions, although those are pretty verbose.