使用SQL，我如何从一个逗号分隔列表的2d数组创建一个新表？

-- 创建新表
CREATE TABLE new_table (
  id INT,
  value TEXT
);

-- 原始逗号分隔的2D数组
DECLARE @csv_array TEXT = '1,2,3;4,5,6;7,8,9';

-- 拆分逗号分隔的2D数组为行
WITH split_rows AS (
  SELECT 
    SPLIT_PART(row_values, ',', 1) AS col1,
    SPLIT_PART(row_values, ',', 2) AS col2,
    SPLIT_PART(row_values, ',', 3) AS col3
  FROM (
    SELECT UNNEST(STRING_TO_ARRAY(@csv_array, ';')) AS row_values
  ) AS rows
)

-- 插入拆分后的值到新表
INSERT INTO new_table (id, value)
SELECT 
  CAST(col1 AS INT),
  col2 || ',' || col3
FROM split_rows;