@hadley wondering what you think of using the sql server regexp functions introduced in SQL Server 2025 https://learn.microsoft.com/en-us/sql/t-sql/functions/regular-expressions-functions-transact-sql?view=sql-server-ver17?

This would allow supporting stringr functions like str_detect() and str_replace() which are currently not supported by dbplyr for SQL Server. But, then this would require the user to be on SQL Server 2025. I'm not sure how dbplyr typically deals with supporting different versions of a given database management system?