title: Doctrine Native query inside query builder join
body: <p>I am working on a query on Doctrine 2 (with Symfony 2.8)</p>
  
  <p>I have this query giving me relevant info:</p>
  
  <pre><code>    $qb = $this-&gt;createQueryBuilder('ea');
              $qb-&gt;join('ea.entity_b', 'eb')
                  -&gt;join('ea.entity_c', 'ec')
                  -&gt;join('ec.entity_d', 'ed')
                  -&gt;join('MainBundle:Entity_E', 'ee','WITH', 'ee.column1 = ea.id')
                  -&gt;join('MainBundle:Entity_F', 'ef', 'WITH', 'ea.column1 = ef.id');
  </code></pre>
  
  <p>Now, I need to add extra info to that query, but it comes from a native SQL, something like this:</p>
  
  <pre><code>SELECT * FROM DS ORDER BY id DESC LIMIT 1
  </code></pre>
  
  <p>And make sure that the id of the result from the native query is equal to ef.id</p>
  
  <p>I hope I made any sense.</p>
  
  <p>Thanks</p>