Scalar user-defined functions (UDFs) - Complex control flows in computation-based UDFs
Data Warehouse · Public preview · Planned
Description
We're expanding the capabilities of scalar user-defined functions. This update unlocks new scenarios for **computation**-based UDFs, including support for while loops, multiple return statements, and complex control flows. Computation-based scalar UDFs can now be used in additional query shapes, including Common Table Expressions (CTEs) and within GROUP BY, HAVING, and ORDER BY clauses.
Change History
-
2026-04-23
Roadmap Item Added
Workload: Data Warehouse