placeholders = ':' + ', :'.join(list(my_dict.keys()))
query = 'INSERT INTO my_table (%s) VALUES (%s)' % (columns, placeholders)
print(query)
cur.execute(query, my_dict)
con.commit()
Python Sqlite3: INSERT INTO table VALUE (сюда идет словарь)