Whenever I use the field name “level” or “group” in my suiteql query it crashes. Why? What can I do?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** The issue you're experiencing with your SuiteQL query crashing when using the field names "level" or "group" is likely due to these being reserved keywords in SQL. Reserved keywords are words that have special meaning in SQL and cannot be used as identifiers (such as column names, table names, etc.) unless they're quoted. To resolve this issue, you can use double quotes around the field names in your query. This tells the SQL interpreter to treat these words as identifiers rather than reserved keywords. Here's an example:

sql
SELECT "level", "group" FROM myTable

Please note that SQL is case-sensitive when identifiers are quoted. So, if your actual field names are in uppercase, you should use them in uppercase within the quotes. Also, be aware that using reserved keywords as identifiers can lead to confusion and is generally discouraged. If possible, consider renaming these fields to avoid conflicts with SQL reserved keywords.