Include string manipulation functions already available in other sql editions/versions like string_agg, string_split etc
String_Agg and String_Split are not supported by Azure Synapse SQL Analytics.
Ward Eerland commented
As of the July release of Azure Data Warehouse, STRING_AGG is implemented.
Bala U commented
The Workaround provided uses recursive CTE which is again not supported in Azure SQL DW.
If added, the feature will be really helpful in many cases.
Sambhav Jain commented
+1 Really looking forward having this feature which is important for us.