Concatenate Column and value as property To existing JSON object in another column In SQL Server

Question

Let's say I have the following table Product

Answer 1

You can use a nested FOR JSON subquery, which breaks open the original JSON using OPENJSON and re-aggregates it

SELECT
  p.ProductID,
  p.ProductName,
  (
      SELECT
        p.ProductID,
        p.ProductName,
        j.Price,
        j.Shipper
      FROM OPENJSON(p.Results, '$.Results')
        WITH (
            Price int,
            Shipper varchar(100)
        ) j
      FOR JSON PATH, ROOT('Results')
  ) AS Results
FROM Product p;