Spotfire Ideas Portal
When you use Query spreadsheeds (advance query builder) environment, you are limited to set of basic SQL statements (due to StaOLEDB provider?). I propose to enhance its functionalities to use more SQL statements and functions which are not supported at the moment to have more possibilities concerning SQL statements (you are writing SQL statements in the node, so you expect that SQL functions are supported - like in other nodes like Python or R, you expecting whole functionality). I recently came across several useful functions (e.g. SQL windows functions like OVER) but there will be much more of them. Please, revise this idea. Thanks
I would like to add one point of view to that. Availability of SQL functions also for Query Spreadsheets node is equivalent to availability of SQL scripting in the product, correct? We have already R, Python, C#, SVB, Spark scripting available. Why to not extend it to SQL scripting as well.