db = sqlite3.connect(':memory:')
c = db.cursor()
c.execute('CREATE TABLE status(location TEXT, arrival TEXT, departure TEXT)')
SQL = 'INSERT INTO status VALUES (:location, :arrival, :departure)'
f = lambda : None
row1 = defaultdict(f, {'location': 'place1', 'departure': '1000'})
row2 = defaultdict(f, {'location': 'place2', 'arrival': '1010'})
rows = row1, row2
c.executemany(SQL, rows)
db.commit()
c.execute('SELECT * FROM status')
print(list(zip(*c.description))[0])
for r in c.fetchall():
    print(r)
db.close()
python sqlite вставить именованные параметры или ноль