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 overhead.

Microsoft debuted SQL Server 2019 at Ignite, but a more technically detailed picture of the next-gen database platform emerged only later at the PASS Summit. ... Scalar Function Inlining ...