title: Using a 'case when' in a Doctrine select statement
body: <p>I have a select query I'd like to perform with Doctrine:</p>
  
  <pre><code> $resultset = Doctrine_Query::create()
      -&gt;select("t.code, t.description, case when t.id_outcome = 1 then 1 else 0 end as in_progress")
      -&gt;from('LuOutcome t')
      -&gt;orderBy('t.rank')
      -&gt;fetchArray();
  </code></pre>
  
  <p>And it barfs on the 'case'. The documentation does not mention that it's possible (or not).</p>
  
  <p>I'm wondering if Doctrine lacks the capacity to do so. If so, it's a rather major omission. Does anyone know of a work-around?</p>