feature request: iterate over more than 1 record

[databasedav]

something like this

async for rows in database.iterate(query, values, n=10):
    rows

where rows would have 10 rows until there is <10 to be returned and it would simply return the rest

[sobolevn]

I think that a proper way to do that is to use something like https://aioitertools.omnilib.dev/en/stable/api.html#aioitertools.itertools.islice