Adding support for recursive CTEs in a warehouse

[pmscorca]

Hi,

I've noticed that T-SQL language of a warehouse doesn't support the recursive CTEs. It'a real pity!

A such feature is more useful and comfortable one in several scenarios, f.e. to navigate an hierarchy.

I hope it will be implemented as soon as possible. Thanks

[sanjeevkamboj13]

i agree if we think from referential integrity constraint . but we can use utility functions to verify the data before inserting . defiantly not possible for any manual insertion

[phil_mad]

Recursive SQL for wh and lh endpoint is definitely a must have for a serious platform. The sql server object supports this but you can't build directly a semantic model on it. At least i haven't found this yet.

[hedeencharles]

This is a must have feature for us. We understand it was not available in Synapse but would like to see it in Fabric Data Warehouse. Any update MS team?