title: How to manipulate a column selected by * in SQLite?
body: <p>I want a query to return all rows and all columns with one caveat: if, in a given row, colN is null, then instead return the string 'FOO'. </p>
  
  <p><strong>Why dont I just use <code>SELECT col1, col2, ..., COALESCE(colN, 'FOO')</code>?</strong></p>
  
  <p>I am implementing an abstract interface and thus I am required to use <code>SELECT</code> queries which <code>SELECT *</code> (because I cannot make assumptions on what columns there are). I can only assume 1 columns exists: colN.</p>
  
  <p><strong>What would this provide me?</strong></p>
  
  <p>I need this because this query is used in combination with a UNION and this allows me to keep track of the origin of the data.</p>
  
  <p>Any ideas on how to do this?</p>