title: How to Hydrate custom query in Symfony/Doctrine
body: <p>After performing a custom query using </p>
  
  <pre><code>$DBH = Doctrine_Manager::getInstance()-&gt;connection()-&gt;getDbh();
  $PDO = $DBH-&gt;prepare("mysql query");
  $PDO-&gt;execute();
  </code></pre>
  
  <p>How do I return model objects instead of record arrays? </p>
  
  <p><strong>EDIT</strong>
  I got mine working by using something like this: <code>$data_object = doctrine_core::getTable('table_name')-&gt;find('id_from_raw_SQL')</code>. Easy as pie! And thanks to Dan for the hint. </p>