title: OperationalError: near ":1": syntax error in SQLite
body: <p>I have this error.</p>
  
  <p>My Table column names are as followed after i performed join and union:</p>
  
  <pre><code>['A','B','C','B:1','D','B:2','E']
  </code></pre>
  
  <p>In order to drop/rename the Table columns, I executed this query:</p>
  
  <pre><code>query = '''
          CREATE TABLE New_Table
          ['A','B_a','C','B_b','D','B_c','E']
          '''
  query1 = '''
          INSERT INTO New_Table
          ('A','B_a','C','B_b','D','B_c','E')
          SELECT A, B, C, B:1, D, B:2, E
          FROM Table
          '''
  
  import sqlite3
  conn = sqlite3.connect('dbase_Sqlite')  # create or open db file
  curs = conn.cursor()
  curs.execute(query)
  conn.commit()
  curs.execute(query1)
  conn.commit()
  </code></pre>
  
  <p>I got this error:  </p>
  
  <pre><code>OperationalError: near ":1": syntax error
  </code></pre>
  
  <p>Apparently the ":1" and ":2" were added by the sqlite JOIN or UNION earlier. How should i deal with it?</p>