Support Commen Table Expression (WITH) in data connection custom query

This Idea is from 2016 and is not implemented yet. BTW, all ideas are flagged as Future Consideration...

The error message you get is

External error:
Incorrect syntax near the keyword 'WITH'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Incorrect syntax near ')'.

I would like to do an analysis of hierarchy data, where I need to use recursive CTE. For this I would create a custom query in Spotfire, but this cannot do this at the moment, because custom query does not work with CTE.

Example data

Example query

List of all employees reporting to Bastian (Denis, Eliot), not only direct reports (Denis).

"Bastian" would be a parameter in the custom query.

I'd use it

It doesn't look like many Spotfire competitors support CTE's, so this would provide an advanced feature if it was supported by Spotfire.

A reply from Doug Johnson, Senior Technical Support Engineer (09/19/16) working on my question "Why Spotfire does not support CTE":

"Unfortunately, Spotfire does not currently support common table expressions.

I have linked this support request to an existing enhancement request that asks for this capability, and linked it to this support request in our database. 
The title of the enhancement request is
  "Simplify complex queries by adding WITH statements (also known as common table expressions, or sub-query factoring clauses) to the custom query functionality."
Our Product Management team will review it periodically as part of our release planning process.  Product Management will be able to find the enhancement request by following the link to it from this support request."