Is it possible to use a subquery in SuiteQL select clause?

AI generated answer (using internal Slack threads):

Based on the conversations provided, it is not explicitly mentioned whether a subquery can be used in a SuiteQL select clause. However, it is mentioned that SuiteQL allows for ad-hoc joins, which suggests a level of flexibility in constructing queries. This might imply the possibility of using subqueries, but without a direct reference or example, it cannot be definitively confirmed. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******