I'm using Tim's suiteql tool. I can select * from a customlist, it's working fine. But when I use it in Netsuite scripting, it's failing. Any idea why ?

He wraps it with

'SELECT * FROM ( SELECT ROWNUM AS ROWNUMBER, * FROM (' + requestPayload.query + ' ) ) WHERE ( ROWNUMBER BETWEEN ' + paginatedRowBegin + ' AND ' + paginatedRowEnd + ')';

Tim's sqltool use NetSuite scripting, what other can use? What roles you are using when run sqltool. and your script?