what are the key changes from SQL to SuiteQL and where can I find that information

AI generated answer (using internal Slack threads):

SuiteQL is a powerful tool that allows you to use SQL-like syntax to query your NetSuite data. Here are some key changes when transitioning from SQL to SuiteQL: 1. Object Model vs Database: SuiteQL works directly with the database, unlike Saved Searches which work with the object model. This means that some data that are "calculated" and do not exist in database tables might not be accessible via SuiteQL. 2. Performance: According to some users' experiences and NetSuite's claims, SuiteQL can be significantly faster than the Search API. However, this might vary depending on the complexity and size of your data sets. 3. Syntax and Functionality: SuiteQL allows for more freedom in using multilevel joins, aggregate functions, and nested selects, which can be more familiar and easier to use for those with SQL experience. 4. Integration with SuiteScript: SuiteQL can be used within SuiteScript, allowing for more complex and powerful scripts. As for where to find this information, you can refer to the official NetSuite documentation and SuiteAnswers for detailed information on SuiteQL. You can also find example queries and comparisons between SuiteQL and the Search API on various blogs and forums. Remember to always test your queries and scripts thoroughly to ensure they work as expected and provide the desired performance benefits. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******