sqlite (python) how to add data to given column

Can you give me advice how to insert data into specific column in table (example, name1,2,3 are the names of ROWS)

name1 | name2 | name3|... eric | anna | john |...

please do not say to put it like:

|names| |eric | |anna | |john |

because it is just example. how can i access all of rows using variable? because cursor.execute("INSERT INTO foo(:iter) VALUES(...)",{'iter': iterator}) returned error. PLS gimme advice. Thanks :)