sql reader is not setting query result variables

[marcghaly]

In the following dataflow, trying to use output mapping for the sql reader will not work as the result of the query is not set

Instead of manually entering the integer representing the student role, retrieving it from db would be a better option in case it ever changes

[brendanheywood]

This looks to me like you want to use an sql flow step as a once off connector step and just save it's output into a step variable rather than the flowing record. I think that is a perfectly valid business case and we can either implement a second sql connector step in the mean time before #422 is implemented which I am expecting to be a fairly large internal refactor.

If this is blocking then lets just clone the sql flow step into a sql connector step for the time being and we can merge them later.