title: How to do IF NOT EXISTS in SQLite
body: <p>I am trying to port this line from MS SQL Server to SQLite</p>
  
  <pre><code>IF NOT EXISTS(SELECT 1 FROM EVENTTYPE WHERE EventTypeName = 'ANI Received') 
      INSERT INTO EVENTTYPE (EventTypeName) VALUES ('ANI Received');
  </code></pre>
  
  <p>It seems that SQLite does not support IF NOT EXISTS or at least I can't make it work.
  Am I missing something simple?  Is there a workaround?</p>