USQL - Allow Constants to be assigned to Columns in the JOIN Conditions
In Join Conditions, Both sides of the == operator should be columns names, we cannot use values as in SQL. Can we add support for this?
For Example – JOIN ON Eng.EngagementSID == Prj.EngagementSID AND Eng.DataSourceSID == 2 should be allowed
Michael Rys commented
Why can't you just move the constant comparison into the WHERE clause?