Planned Public preview Date: Q2 2026
Computation-based scalar UDFs now support WHILE loops, multiple RETURN statements and deeply nested IF-THEN-ELSE blocks in the function body. They can also be used in queries that include Common Table Expressions (CTEs), and within GROUP BY, HAVING, and ORDER BY clauses.