Got it! Hmm, I've submitted a feature request for better support here. Currently, it looks like we don't support result pagination 
You won't be able to access the client directly, and the only resource/query config setting I'm aware of on the Retool side would be the max timeout setting of 2 minutes.
As a workaround, I'm wondering if you could call each page of results & combine the results using a JS loop