Enable Enterprise Ad-Hoc Configuration with Input node to use Substitution-based parameterization

I have a query that must contain certain criteria in order to be accepted by the data source.  In order to make this query more flexible I need to use substitution based parameterization for those criteria fields.  However, I also want to use the adhoc configuration with Input node to pass arguments to those parameters from an input spreadsheet.  The current node does not support that functionality

We can propose three solutions to this issue:

1.  Create a new type of operation that will allow input spreadsheet fields to be passed to substitution-based parameters

2.  Consider adding a REPLACE operator in EM where it would find the where clause in the query and replace it with the choice made dynamically, rather than use the value defined in the query ( instead of adding it on).

3.  Allow the Enterprise ad-hoc with input data node to disregard the defaults specified in a parameterized query when inputs are passed from a spreadsheet.   This would allow me to create the initial "dummy" query in Enterprise manager then replace the original criteria when running the Ad-hoc node.