title: getting result set into DTO with native SQL Query in Hibernate
body: <p>I have a query like below</p>
  
  <pre><code>select f.id, s.name, ss.name
  from first f
  left join second s on f.id = s.id
  left join second ss on f.sId = ss.id
  </code></pre>
  
  <p>If I could use HQL, I would have used <a href="http://docs.jboss.org/hibernate/core/3.3/reference/en/html/queryhql.html#queryhql-select" rel="noreferrer">HQL constructor syntax</a> to directly populate DTO with the result set.
  But, since hibernate doesn't allow left join without having an association in place I have to use the Native SQL Query.</p>
  
  <p>Currently I am looping through the result set in JDBC style and populating DTO objects.
  Is there any simpler way to achieve it?</p>