Planned Public preview Date: 2026-06-30
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.