Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

Ali Shashaani

← Customer Feedback for ACE Community Tooling

My feedback

  1. Support for Recursive CTE

    196 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    under review  ·  9 comments  ·  Azure Synapse Analytics » SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    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.

    Ali Shashaani supported this idea  · 

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice