Regex support in lakehouse/datawarehouse

[alexsilviu05]

SQL Server 2025 adds Regex functions support, this is present also in SQL database in Fabric, Azure SQL DB and Azure Managed Instance as per:

https://learn.microsoft.com/en-us/sql/relational-databases/regular-expressions/overview?view=sql-ser...

it would be beneficial to have Regex support also in lakehouse and warehouses.

[sahinad]

I have just tested it via the SQL analytics endpoint and am disappointed that it is not working yet 😞 I am looking forward to seeing this features in the lakehouse.

[Anonymous]

I hope this simple query will work : SELECT * FROM REGEXP_SPLIT_TO_TABLE('a.b.c', '\.');