Many of the tasks and plans that need to accomplish tasks will need to know how to do sql queries.
This ticket will create a sql query task so that plans will have the ability to execute t-sql code on a server.
The result of this task should always be a json object representing the resultset of the query.
The raw task should not be exposed to users of the PE console, as we don't want console users to be able to execute arbitrary t-sql via the console. This task should only ever be consumed by plans so that the basic query, if not all of it's parameters, can known via a code review process prior to implementing.
Need to decide on a strategy to accomplish this. May have to write a new PowerShell cmdlet that will do a query and return json.