In mybatis we can define very complex mapping of the sql result set to an arbitrary complex dto object. Take a look at the example here:
http://www.mybatis.org/mybatis-3/sqlmap-xml.html
at the section "Advanced Result Maps" where we have a mapper for the Blog which has single author and the collection of posts and every post has a collection of comments and tags.
The question is: Is it technically possible and how in JPA/Hibernate to create SqlResultSetMapping that maps native sql query like this in previous example to the dto object like this (Blog) in previous example? The assumption is that the Blog is not part of our entity model but some dto object for the specific use case. If this can't be achieved by using SqlResultSetMapping what is the best way to achieve this in JPA/Hibernate under the assumption that Blog, Post, Comment... are some specific dto objects for the specific use case?
Please keep in mind that this is only the example for illustration and that focus in on "is this technically possible and how" and not on "why should someone do such a thing in this example when you can define JPA relations and let framework generate sql for you...".
