title: symfony2 / doctrine2 - dql subselect
body: <p>is it possible to get data with a subselect in dql and putting the result in a class attribute which is not a entity column?</p>
  
  <p><strong>hasfreelist</strong> is a class attribute but not a entity column in mysql.</p>
  
  <p>This is my dql:</p>
  
  <pre><code>SELECT e, DATE(e.begin) dbegin, 
  (SELECT COUNT(g) FROM AcmeDemoBundle:list  g WHERE e.id = g.fkevent) AS e.hasfreelists     
  FROM AcmeDemoBundle:event e JOIN e.fklocation l 
  WHERE e.enabled=1 e.begin&gt;=:from 
  ORDER BY dbegin, e.topevent DESC
  </code></pre>
  
  <p>I have the following error:</p>
  
  <pre><code>An exception has been thrown during the rendering of a template 
  ("[Syntax Error] line 0, col 143: Error: 
  Expected Doctrine\ORM\Query\Lexer::T_FROM, got '.'")
  </code></pre>
  
  <p>But it tells me nothing.
  Thank you for you help.</p>