Can you use CTEs with SuiteQL? Doesn't seem to work for me... is there any similar way to organize multiple select expressions within one query?

@NS You can use the WITH clause. For example:

WITH ActiveEmployees AS
	(
		SELECT
			FirstName,
			LastName
		FROM 
			Employee 
		WHERE 
			IsInactive = 'F'
	)
SELECT
	FirstName,
	LastName
FROM
	ActiveEmployees

Thank you, that's what I was looking to do!