title: Using subqueries with doctrine / Errors with aliases
body: <p>I'm trying to make a simple query with a subquery in a orWhere clause (with Doctrine).</p>
  
  <p>As always, Doctrine tries to rename every aliases and completely destroys the queries...</p>
  
  <p>Here's an example:</p>
  
  <pre><code>$q = Doctrine_Query::create()
      -&gt;from('Actualite a')
      -&gt;where('a.categorie_id =?', $id)
      -&gt;orWhere('a.categorie_id IN (select id from cat.categorie as cat where cat.categorie_id =?)', $id)
      -&gt;execute();
  </code></pre>
  
  <p>Which in MySQL would make something like:</p>
  
  <pre><code>SELECT * 
  FROM actualite a 
  WHERE a.categorie_id = 1 OR a.categorie_id IN (SELECT cat.id FROM categorie cat WHERE cat.categorie_id = 1);
  </code></pre>
  
  <p>Everything is right about it, but then again Doctrine destroys it:
  Couldn't find class cat</p>
  
  <p>Every time I try to do something a little complex with Doctrine, I have errors with aliases. Any advice or ideas about how to fix this?</p>
  
  <p>Thanks!</p>