Simple way to use an interable rather than a list for executing queries across many values.

execute_from_iterable.py

import itertools

def execute_from_iterable(conn, query, values_iterable, batch_size=1000):
    values_iterator = iter(values_iterable)
    while True:
        batch = list(itertools.islice(values_iterator, batch_size))
        if not batch:
            return
        conn.execute(query, batch)