Scalar UDFs - Expanded T-SQL constructs and query shapes for computation-based UDFs

Data Warehouse · Public preview · Planned

Data Warehouse Public preview Planned
Last Modified: May 13, 2026 Release Date: Q2 2026

Description

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.

📰 Related Blog Article

Inline Scalar user-defined functions (UDFs) in Microsoft Fabric Warehouse (Preview)
🔗 blog.fabric.microsoft.com

Change History

  1. 2026-05-13
    Feature 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. -> 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. Name Scalar User-defined functions (UDFs) - Complex control flows in computation-based UDFs -> Scalar UDFs - Expanded T-SQL constructs and query shapes for computation-based UDFs
  2. 2026-04-23
    Roadmap Item Added
← Back to Roadmap 👁️ Watch this Feature View API JSON Workload: Data Warehouse