Is there a non-CLR string splitter for SQL Server 2016 that performs well for very large input strings and returns a reliable ordinal column like `STRING_SPLIT` can on SQL Server 2022 and Azure?
This inline TVF converts the input string to JSON array format, then uses default `OPENJSON`. db<>fiddle: <>https://dbfiddle.uk/?rdbms=sqlserver_2016&fiddle=fdb7fca0e2d2c232afd527fa59783e71