[Zope] Programatically setting advanced settings in zsql methods

Hello ... I have a python based product where I am creating a few zsql methods at the time of instantiation. I recently realized that there is the default 1000 row maximum limit on query rows. While this can be changed through the management interface, I am trying to figure out how to do this when I create the SQL method in the python code. Is this possible? Thanks -Jeff