Recursive Common Table Expressions are now supported in Databricks! This brings a native way to express loops and traversals in SQL when working with hierarchical and graph-like structures. Plus, support for recursive CTEs simplifies migrations from legacy database systems. See