title: SQLite: Something like Oracle Decode or MS "If"
body: <p>In the past, I've used "decode" in Oracle, and "iif" in Microsoft, in the SELECT stmt of an SQL query.</p>
  
  <p>I've been considering SQLite for a project, but as far as I can tell, conditionals in the SELECT stmt are difficult.  Googling brings up the use of CASE.. but intuitively, that seems that the performance would not be very good, not to mention more difficult to code.  Or maybe I don't fully understand it.</p>
  
  <p>Thoughts or advice from anyone? I'd really like to use SQLite for this project.</p>