Feature request : support accumulations on output (compound assignments)

[Fleid]

The UPDATE and MERGE commands in SQL allow compound assignments:

+= Add and assign -= Subtract and assign

I can't think of a way to do that with the current output binding. Supporting these assignments would allow us to build accumulations (materialized views).

[dzsquared]

example implementation in full code: https://docs.microsoft.com/en-us/azure/stream-analytics/sql-database-upsert#option-2-merge-with-compound-assignment-accumulate-via-a-custom-sql-query

[Fleid]

Drew, I suppose this is for others stumbling on this issue?

[dzsquared]

@Fleid - yep! adding just a bit more context as we get more traffic.