title: SQLite: Stop insertion on: expected n columns but found m
body: <p>I'm using the <code>.import</code> command to insert a large csv into an SQLite db. Unfortunately, some of the lines contain the delimeter inside the value for the field. For example, each line is in the form:</p>
  
  <pre><code>id, title, first name, last name, location 
  </code></pre>
  
  <p>but some lines have values like:</p>
  
  <pre><code>1, Mr, Bob, Saget, Sydney, Australia
  </code></pre>
  
  <p>and the comma in the location field causes an <code>expected 5 columns but found 6</code> error. Luckily, it's not important to me to insert every line, so I'd like to just not insert any lines that raise this error. Is this possible?</p>
  
  <p>Parsing the csv with regex is a last resort as the file is very large and could take minutes every time I need to import it.</p>