Just a heads-up: In NS 2024.2, there appears to be a SuiteQL defect that sometimes causes column names in the responses to be returned incorrectly. The columns are returned with names such as "referenced_12, "referenced_13," and so on. From what I can tell, this sometimes occurs when using queries where multiple joins are involved. A workaround that I found is to add aliases to the columns that are being returned incorrectly. Hope this helps.