Anonymous
Not applicable

Spark SQL does have Common Table Expressions: https://spark.apache.org/docs/latest/sql-ref-syntax-qry-select-cte.html

I'm not an expert at SQL or CTEs, but my guess is that it's the recursion option.