SuiteQL in the N/query Module
In SuiteScript, you can create and run SuiteQL queries using the N/query module. Queries created using SuiteQL can be more powerful and flexible than queries created using other APIs in the N/query module. SuiteQL queries can also provide the best query performance for many use cases. You can create your own SuiteQL query strings, which lets you design and run complex SQL queries that cannot be created otherwise. For examples of SuiteQL queries you can create, see Examples of Using SuiteQL in the N/query Module.
helpcenter.nl?fid=section_157960623712.html