Make the cursor object scrollable so we can tell the server to scroll forward X rows without having to do a fetchmany(X) and have to do a transfer of data for those rows. For example here is how it used in the oracle db connector

https://python-oracledb.readthedocs.io/en/latest/user_guide/sql_execution.html#scrollablecursors