title: Using IFNULL in sqlalchemy core
body: <p>I'm trying to use sqlalchemy core select rows from a <code>mysql</code> table using <code>IFNULL</code>.</p>
  
  <p>Given a table like so:</p>
  
  <pre><code>id    int1    string1   other
  1      7        NULL    other stuff
  2      NULL     bar     more stuff 
  </code></pre>
  
  <p>The sql would be something like:</p>
  
  <pre><code>SELECT IFNULL(int1, 0) AS int1, IFNULL(string1, '') AS string1 FROM table
  </code></pre>
  
  <p>Is this possible using the core? What would be great would be something like</p>
  
  <pre><code>s = select(ifnull(table.c.int1, 0), ifnull(table.c.string1, ''))
  </code></pre>