can you reference a SuiteQL in a suiteScript

AI generated answer (using internal Slack threads):

Yes, you can reference a SuiteQL in a SuiteScript. SuiteQL is a powerful tool within NetSuite that allows you to perform ad-hoc joins and complex queries that might not be possible with traditional N/search. It is a layer on top of Oracle SQL and is read-only. Here is an example of how you can use SuiteQL within SuiteScript:

javascript
var suiteQL = "SELECT * FROM transaction WHERE entity = 123";
var result = N/query.runSuiteQL({query: suiteQL});

In this example, a SuiteQL query is defined and then run using the

N/query.runSuiteQL

method. The result is then stored in the

result

variable. Please note that SuiteQL is native to NetSuite and not a third-party tool. You can find more information about SuiteQL by typing 'SuiteQL' into NetSuite's help. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******