如何使用逗号分隔值查询字段中的SQL行(数组值)？

DECLARE @csv NVARCHAR(MAX) = 'value1,value2,value3';
DECLARE @field_index INT = 1;

SELECT 
    SUBSTRING(@csv, 1, CHARINDEX(',', @csv, 1) - 1) AS Field1,
    SUBSTRING(@csv, 
              CHARINDEX(',', @csv, 1) + 1, 
              CHARINDEX(',', @csv, CHARINDEX(',', @csv, 1) + 1) - CHARINDEX(',', @csv, 1) - 1) AS Field2,
    SUBSTRING(@csv, 
              CHARINDEX(',', @csv, CHARINDEX(',', @csv, 1) + 1) + 1, 
              LEN(@csv) - CHARINDEX(',', @csv, CHARINDEX(',', @csv, 1) + 1) - 1) AS Field3

CREATE FUNCTION dbo.SplitCSV
(
    @csv NVARCHAR(MAX)
)
RETURNS TABLE
AS
RETURN
(
    SELECT 
        ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RowNumber,
        VALUE
    FROM 
        STRING_SPLIT(@csv, ',')
);

DECLARE @csv NVARCHAR(MAX) = 'value1,value2,value3';

SELECT * FROM dbo.SplitCSV(@csv);

DECLARE @csv NVARCHAR(MAX) = 'value1,value2,value3';

SELECT 
    JSON_VALUE(value, '$[0]') AS Field1,
    JSON_VALUE(value, '$[1]') AS Field2,
    JSON_VALUE(value, '$[2]') AS Field3
FROM 
    OPENJSON(CONCAT('["', REPLACE(@csv, ',', '","'), '"]'))