title: Doctrine 2 - COALESCE and CONCAT
body: <p>I have this DQL Query:</p>
  
  <pre><code>$repository-&gt;createQuery("SELECT f.id, COALESCE(f.name, 
  CONCAT(f.floor_number, ' NP')) as name FROM ".__NAMESPACE__.'\\Floor f 
  WHERE f.building = ?1')
          -&gt;setParameter(1, $this-&gt;building);
  </code></pre>
  
  <p>but it doesn't work - i get </p>
  
  <pre><code>[Syntax Error] line 0, col 36: Error: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got '('
  </code></pre>
  
  <p>The reason is usage of CONCAT inside COALESCE.... is there any way how to make this work (without native query)?</p>