Froid

Froid is an extensible, language-agnostic framework for optimizing imperative functions in databases. Currently, the benefits of UDFs (User-Defined Functions) such as modularity, readability, code reuse come with a huge performance penalty. The purpose of Froid is to enable developers to use the abstraction of UDFs without compromising on performance. Froid introduces a radically different approach to evaluating imperative UDFs that results in improvements of up to multiple orders of magnitude over the current state of the art.

Aggify (opens in new tab) is a related project that broadens the scope of Froid and expands its applicability by allowing optimization of cursor loops in UDFs.

Froid is available as “Scalar UDF Inlining” in Microsoft SQL Server 2019 (Read the documentation) (opens in new tab)