Anyone noticing that the schema browser doesnt match your installation/account? Ex:

select id,inventorynumber,expirationdate,quantityonhand from inventorynumber

https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/inventorynumber.html

Error Response
Http Code: BadRequest Bad Request 
{"type":"<https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1>","title":"Bad Request","status":400,"o:errorDetails":[{"detail":"Invalid search query. Detailed unprocessed description follows. Search error occurred: Unknown identifier 'quantityonhand'. Available identifiers are: {inventorynumber=inventorynumber}.","o:errorQueryParam":"q","o:errorCode":"INVALID_PARAMETER"}]}

Surprisingly select * works fine but only returns results with id,expirationdate,inventorynumber,item columns... weird. InventoryNumberLocation table has the data I needed, but the schema didnt match at all. FYI.