你只需要添加一个PIVOT子句：

WITH request
as
(
    SELECT requestId,
           property1191,
           '['+replace(replace(property1191, '[', ''), ']', '')+']' as json
    from capex_management_requests
)
SELECT *
FROM
(
    SELECT P.requestId, AttsData.[Id], AttsData.[data], ROW_NUMBER() OVER (PARTITION BY P.requestId,AttsData.[Id] ORDER BY (SELECT 1) ) AS row_id
    FROM request P CROSS APPLY OPENJSON (P.json, N'$') 
    WITH 
    (
        Id VARCHAR(200) N'$.metaId',
        data VARCHAR(200) N'$.data'
     ) AS AttsData
) DS
PIVOT 
(
     MAX(data) FOR Id IN ([690], [1192])
) piv;

如果你想要动态的，你需要首先在一个临时表中具体化结果：

DROP TABLE IF EXISTS #DataSource;

WITH request
as
(
SELECT requestId,
       property1191,
       '['+replace(replace(property1191, '[', ''), ']', '')+']' as json
from capex_management_requests
)
SELECT requestId, [690], [1192]
INTO #DataSource
FROM (
    SELECT P.requestId, property1191, AttsData.[Id], AttsData.[data]
    FROM request P CROSS APPLY OPENJSON (P.json, N'$') WITH (
        Id VARCHAR(200) N'$.metaId',
        data VARCHAR(200) N'$.data'
      ) AS AttsData
) src

DECLARE @DynammicTSQLStatement NVARCHAR(MAX)
       ,@DynamicPIVOTColumns NVARCHAR(MAX);

SELECT @DynamicPIVOTColumns = STRING_AGG(CAST(QUOTENAME([Id]) AS NVARCHAR(MAX)), ',') WITHIN GROUP (ORDER BY [Id])
FROM
(
    SELECT DISTINCT [Id]
    FROM #DataSource
   
) DS ([EVT]);

SET @DynammicTSQLStatement = N'
SELECT *
FROM #DataSource
PIVOT
(
    MAX([data]) FOR [Id] IN (' + @DynamicPIVOTColumns + ')
) PVT';

EXEC sp_executesql @DynammicTSQLStatement;