Support for Recursive CTE
It would be great if you can add support for recursive CTEs for computing hierarchical data

8 comments
-
Singhal, Himanshu commented
it's a showstopper
-
JJ commented
another BIG limitation or even show stopper if you want to migrate to synapse, please add this essential functionaliity we are used to from sql since many years
-
Ali Shashaani commented
Our need is to traverse complex, unpredictable JSON objects and pull out all elements, not matter how deeply nested they are, into a table of key-value pairs. A recursive CTE with cross application of OPENJSON table-valued function would elegantly take care of this. Pretty, please.
-
Krunal G commented
Work around we used that we get extreme child data or most parent data and run a While loop to get desired output, then we dump the output in Table so as to use in other query/ result set.
-
Vinodh Ramasubramanian commented
Could you provide an update on this request ?
-
Chris Thompson commented
wasn't this "completed" a moment ago??
-
Edward commented
Without recursion we will have to process some of our data outside of Azure DW, which sort of defeats the purpose. Please consider adding this feature!
-
Chris Thompson commented
hmm.. i really could do with this for large parent child issues!