title: Dynamic INSERT Statement in Python
body: <p>I am working on updating some Python code I have been working with and was looking for some advice on the best way to deal with an idea I am working with. The part of my code that I wish to change is :</p>
  
  <pre><code>my_reader = csv.reader(input, delimiter = ',',quotechar='|')
  mouse.executemany("INSERT INTO Example_Input (ID,Name,Job,Salary) VALUES (?,?,?,?)", my_reader)
  </code></pre>
  
  <p>The code works. My question is, can I change the "(?,?,?,?)" into something more dynamic like 'range()' to allow user input. I understand that I would also have to have a dynamic create table statement, so another solution might be to count the number of inputs. </p>
  
  <p>To be a little more clear: for example if I had raw_input("How many variables does the table contain?: ") and the input was 2, the program would know to run as if (?,?).</p>
  
  <p>Thoughts?</p>
  
  <p>(also I am using SQLite3 and python 2.7)</p>