@Shai Coleman Actually, the tool does support "WITH." In your example, the problem seems to be with the "SELECT 1 AS abc" query. Can you try this?

WITH test1 AS (SELECT 1 AS abc FROM DUAL)
SELECT abc FROM test1

Here's another example that works as well:

WITH 
	TestEmployee AS (
		SELECT
			ID,
			( LastName || ', ' || FirstName ) AS FullName,
			Phone,
			Email
		FROM
			Employee
		WHERE
			Email LIKE '%@test.com'
	)
SELECT 
	ID, 
	FullName 
FROM 
	TestEmployee
ORDER BY
	FullName

@tdietrich, thanks, after digging a bit more into it, the actual issue was there was an extra comma between the SELECT and FROM parts, e.g. a simplified query to reproduce:

WITH transaction_line_summary AS (
  SELECT     SUM(foreignamount) AS foreignamount_sum,
  FROM        transactionline
  GROUP BY  transaction
)
SELECT foreignamount_sum FROM transaction_line_summary

That query worked for some reason over the REST API and with NimbusQL, but not with SuiteQL Query Tool.

@Shai Coleman Thanks for letting me know. The new version of the tool (which I hope to release over the weekend) supports running queries "as is" (i.e. without pagination). I just tested it, and your query works when pagination is disabled.

@tdietrich, awesome, thanks