Append new properties to existing JSON object in SQL

Question

I have the following json

{
   "GlobalLimit":100.0,
   "BonusConfigurations":[
      {
         "BonusId":1,
         "BonusAmount":{
            "Amount":0,
            "CurrencyId":"USD"
         },
         "Limit":25.0,
         "TransactionType":"Promotion",
         "TransactionSubtype":"Unknown",
         "CashBackPercentage":2
      }
   ]
}

I want to inject new properties into every item in the BonusConfigurations array to get something like this in sql.

{
   "GlobalLimit":100.0,
   "BonusConfigurations":[
      {
         "BonusId":1,
         "BonusAmount":{
            "Amount":0,
            "CurrencyId":"USD"
         },
         "Limit":25.0,
         "TransactionType":"Promotion",
         "TransactionSubtype":"Unknown",
         "CashBackPercentage":2,
         "InternalDescription":"THIS IS THE NEW CAMPAIGN"
      }
   ]
}

Answer 1

等待大神答复