In order to add more extensibility to the SQL the Custom Query Tab of Data Connection should support Advance Queries like using the "WITH" Clause which is currently not supported in Spotfire Analyst. Also, if my query demands some creation of Temp Table and using that further in my SQL then also it should support multi SQL Statements it like the way it is on the Databases. Providing this feature in Custom Query would make it more powerful and extensible.