Scalar Function Support

[jsmith6]

We are migrating a data warehouse and there is currently no support for SQL Scalar Functions (TVF only supported) in Fabric Warehouse.

[ben_riley]

Yeah, same here, this is a pain as we're having to convert the function code so we can use it in other places like views and procs, but some require a lot of refactoring... please add it 🙂

[Carsten_Wegner]

+1

[M_Schmidbauer]

Migration of our DW-solution from Synapse to Fabric will be enormously more complex if scalar functions are not supported.

Honestly we don´t understand why this rather basic feature is no longer available and hope that it will be implemented soon.

[fbcideas_migusr]

Ditto we use these extensively as most of our code is meta data driven and scalar functions is the code that generates the code for procedures based on install / client base. To migrate our warehouse build to not use them involves mass rewrite of our code.

[SMATIN]

Thank you for your feedback. We are working on adding support for SQL scalar UDFs in Fabric Warehouse. Stay tuned for further updates.

[anon97242]

+1

[SMATIN]

Sql native scalar user-defined functions are are publicly available (preview). See

- CREATE FUNCTION (Microsoft Fabric, Azure Synapse Analytics) - SQL Server | Microsoft Learn

- https://blog.fabric.microsoft.com/blog/inline-scalar-user-defined-functions-udfs-in-microsoft-fabric...

- How to make your SQL scalar user-defined function (UDF) inlineable in Microsoft Fabric Warehouse  | ...

Inlineability plays critial part in understanding requirements. 
Feel free to reply and leave feedback on existing scope.