Dynamic INSERT Statement in Python <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>