Ok may be a dumb question, but can you not just use an IDE for SuiteQL? It says in SuiteAnswers you can use SuiteQL via "the ODBC connector." I connected to ODBC using DataGrip and ran one basic query that was successful to ensure I was pulling data. I tried to run the query below support gave me to pull some info I was looking for and I got a "function not recognized" re: the builtin.df. Is this something that works only through the N/query module in a script?

select type, BUILTIN.DF(status), count(*)  
from TRANSACTION  
group by 1,2  
order by 1,2

Try changing the last two lines to group by type, BUILTIN.DF(status) Order by type, BUILTIN.DF(status)

That was it, thank you @User! should have known SuiteQL might not conform to "regular" SQL.

What version of Oracle Database does NetSuite use? Positional arguments for GROUP BY were only available starting with 23ai

I'm not sure. I'd never use it, it trades clarity for typing fewer characters and they're free 🙂

Agreed 100%

Par for the course that NS's own support gave me a query that doesn't work on their system. 🙄