does suiteql support left or outer joins?

AI generated answer (using internal Slack threads):

Based on the conversations provided, it appears that SuiteQL does support the use of LEFT or OUTER JOINs. However, it's important to note that the syntax must be correct. For example, you may need to specify LEFT/RIGHT OUTER JOIN in your query. In the context of saved searches, they are always OUTER joins. You can simulate other types of joins by using groups and result column formulas, but there may be a performance hit. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******