Spotfire: Common Table Expression SQL query support

Spotfire Information Links do not support Common Table Expression (CTE) SQL queries. If there is a need to use this type of query, as a workaround, it should be enclosed in a a stored procedure or a view first, which then can be queried by Information Link.

As of now. we don't have any timeline for when CTE queries will be supported. The following enhancement request is being considered for future release - https://ideas.spotfire.com/ideas/SPF-I-5132

Reference: 

A Common Table Expression (CTE) in SQL, also known as a WITH query, is a temporary, named result set defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or MERGE statement. CTEs improve the readability and organization of complex queries by breaking them down into logical, manageable blocks. They can also be used in CREATE VIEW statements. 

WITH cte_name (column1, column2, ...) AS (
-- CTE query definition (SELECT statement)
SELECT expression1, expression2, ...
FROM table_name
WHERE condition
)
-- Main query that references the CTE
SELECT *
FROM cte_name
WHERE another_condition;

Additional information:

https://www.atlassian.com/data/sql/using-common-table-expressions