Function inlining in SQL Server 2019. Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined. This means they will be folded into the query and no longer incur the UDF ...

In SQL Server 2019, Microsoft is correcting this by addressing both Master and MSDB, ... At the PASS Summit, I did a demo using a query that called an inline scalar function three times.