title: SQLite: no such column error
body: <p>I'm getting the <code>sqlite3.OperationalError: no such colum: bla</code> error.</p>
  
  <p>I have a sqlite file, which only consists of one table <code>foo</code> with column <code>bar</code>.</p>
  
  <pre><code>connection = lite.connect(db.sqlite)
  def insertEvent(self, bar):            
      with connection:                                                          
          cur = connection.cursor()                                               
          cur.execute("INSERT INTO foo(bar) VALUES (bar);")
  
  insertEvent("bla")     
  </code></pre>
  
  <p>Is my syntax wrong or why am I getting the error? I couldn't find any useful solutions in all the other questions.</p>
  
  <p>Just in case: I'm using the sqlite3 library.</p>