Starting with SQL Server 2019, scalar functions written in T-SQL may ... This new functionality isn’t limited to simple expressions. Some multi-statement UDFs can also be inlined.

As I recall, the scalar function inlining ... The first is support for regular expressions, which has long been a feature gap between Oracle and SQL Server. If you aren't familiar with the dark ...