Support Parameterization of SELECT Clause in Custom Queries

Enable parameterization of the SELECT statement (column list) within custom SQL queries in Spotfire.

Currently, query parameters can be used in filters and conditions, but not to dynamically control which columns are returned. This limits flexibility when building analyses that require dynamic selection of output fields.

Supporting parameterized SELECT clauses would allow:

• Dynamic selection of output columns based on user input

• More reusable and adaptable queries

• Reduced need for multiple similar queries differing only in selected columns

A controlled mechanism to define and pass column selections (e.g., via parameters or expressions) into the SELECT clause would significantly enhance query flexibility and enable more dynamic data retrieval scenarios.

Appropriate validation and safeguards would be required to ensure query safety and prevent misuse.

This capability would improve maintainability and support more interactive, user-driven data exploration.