New parameter for sqlQuery()

[pranavrd]

A select query fetches only up to a 1000 records.
Can this be modified to fetch r number of records?
For e.g.:
results = client.sqlQuery(queryStr,r=100000)

[Razikus]

Hi. Currently you have to ensure to chunk your response per 1000 entries.

You should provide some PRIMARY KEY, like ID INTEGER AUTO_INCREMENT
then query it like this

SELECT id, something FROM XXX WHERE ID > @lastId LIMIT 1000

Then make assigment lastId = result[-1][0]