Add Text Qualifier to STRING_SPLIT Function
It would be nice to have an option to include a text qualifier in this function. This would be very helpful for conversion/etl/data cleansing processes handled via t-sql.
declare @list varchar(100)
set @list = '"Simpson, Homer","Simpson, Bart","Simpson, Lisa"'
select ss.value from STRING_SPLIT (@list, ',', '"') ss