Why am i getting this error? Search error occurred: Failed to parse SQL [SELECT sn.id, sn.record, sn.date, sn.type FROM SystemNote AS sn LIMIT 10 ]: syntax error, state:961(10102) near: AS(7,16, token code:0)

AI generated answer (using internal Slack threads):

The error you're encountering is due to incorrect SQL syntax. In NetSuite's SuiteQL, the

AS

keyword is not used for aliasing. Instead, you should directly use the alias name. Your query should look like this:

sql
SELECT sn.id, sn.record, sn.date, sn.type 
FROM SystemNote sn 
LIMIT 10

In this corrected query,

sn

is used as an alias for

SystemNote

. Please note that NetSuite's SuiteQL has its own syntax and does not fully adhere to standard SQL syntax. Always refer to the NetSuite documentation or the SuiteQL help in NetSuite for the correct syntax and usage. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******