Add Support for Recursive CTEs in Lakehouse, Data Warehouse

Recursive CTEs are incredibly useful for resolving queries against hierarchal data. This is why virtually all major database platforms support recursive CTEs!

There is a starter issue with Apache with some progress made on it, but it seems to be stuck. As a separate matter, docs for TSQL endpoint for Synapse says it does not yet support recursive CTEs there either. So, presumably this needs to be resolved in both DW and LH endpoints, each with separate paths to resolve the gap.

[SPARK-24497] ANSI SQL: Recursive query - ASF JIRA (apache.org)

https://issues.apache.org/jira/browse/SPARK-24497

https://github.com/apache/spark/pull/40744

^^^ Please also make your voice known in both of the above channels!