Yields rows in chunks.

iquery.py

def chunk_query(sql, cursor, chunksize=10):
    """Yields rows in chunks."""
    cursor.execute(sql)
    while True:
        nextrows = cursor.fetchmany(chunksize)
        if not nextrows:
            break
        yield nextrows

def iquery(sql, cursor, chunksize=10):
    """Yields row in chunks."""
    for row in chunk_query(sql, cursor, chunksize=chunksize):
        yield row