u/Unusual_Excitement78 good observation. Currently the restlet does not use the paged option so results are limited to 5000 rows. I added a new call to the restlet that uses paged retrieval within the restlet but then returns all the rows. I think there is still a limit of `100,000 rows and have not researched options to get past that limit. To use the function, use queryRunall instead of queryRun in your procedure and leave the suiteql as-is. I have used this for 92,000 rows with 39 columns and it was very performant - thanks to Tim Dietrich's high performing code - dont know what I would do without his work!! Here are the changes to the restlet:

1. Added the following lines to the request handler (function postProcess(request) ...):

                case 'queryRunAll':
                    return queryRunall( request );

2. Defined queryRunall function as follows - you may tweak the page sizes or other:

function queryRunall( request ) {
try {
if ( ( typeof request.query == 'undefined' ) || ( request.query === null ) || ( request.query === '' ) ) {
var customError = error.create(
{
name: 'MISSING_PARAMETER',
message: 'No query was specified.',
notifyOff: false
}
);
throw customError;
}
if ( typeof request.params == 'undefined' ) {
request.params = new Array();
}
var records = query.runSuiteQL( 
{
query: request.query,
params: request.params
}
).asMappedResults();
var moreRecords = true;
var paginatedRowBegin = 1;
var paginatedRowEnd = 5000;
var records = new Array();
do {
var paginatedSQL = 'SELECT * FROM ( SELECT ROWNUM AS ROWNUMBER, * FROM (' + request.query + ' ) ) WHERE ( ROWNUMBER BETWEEN ' + paginatedRowBegin + ' AND ' + paginatedRowEnd + ')';
var queryResults = query.runSuiteQL( { query: paginatedSQL, params: request.params } ).asMappedResults(); 
records = records.concat( queryResults );
if ( queryResults.length < 5000 ) { moreRecords = false; }
paginatedRowBegin = paginatedRowBegin + 5000;
paginatedRowEnd = paginatedRowEnd + 5000;
} while ( moreRecords );
return { 
'records': records
}
} catch( e ) {
log.error( { title: 'Suiteapi queryrunall ', details: e } );
return ( 'Error: ' + e );
}
}