MS SQL code (T-SQL) and json

Job ID: 32694119

Budget: $10 – $30 USD

I have the following json:

{
"showRandomSections":false,
"sections":[
{
"questionCount":"1",
"folderId":"e1365655-fbe8-46b5-9568-f7b3edae02f2"
},
{
"questionCount":"1",
"folderId":"c24fb55b-16e1-4158-9cd6-6404588ccc09"
},
{
"questionCount":"2",
"folderId":"e1365655-fbe8-46b5-9568-f7b3edae02f2"
}
]
}

Of course the "sections" array can contain many items (in the example just 3).

I have the following table called [Folders] with 2 columns:

NewID, OldID
BF5C9C6C-00AC-467C-8F47-D1ACE582925A, c24fb55b-16e1-4158-9cd6-6404588ccc09
F44EEDC6-88FD-4886-AEF1-8314A1A11FC4, e1365655-fbe8-46b5-9568-f7b3edae02f2

Basically I need a T-SQL script that replaces in the json all old IDs with the new IDs. In other words, given the json above, I expect the following json as output:

{
"showRandomSections":false,
"sections":[
{
"questionCount":"1",
"folderId":"F44EEDC6-88FD-4886-AEF1-8314A1A11FC4"
},
{
"questionCount":"1",
"folderId":"BF5C9C6C-00AC-467C-8F47-D1ACE582925A"
},
{
"questionCount":"2",
"folderId":"F44EEDC6-88FD-4886-AEF1-8314A1A11FC4"
}
]
}

I don't want to use loops or cursors. Maybe this link can help you, I found it by googling but I'm not sure it can be applied to my case: https://stackoverflow.com/questions/56996587/update-json-value-from-sql-column-value

PS: Before bidding please read carefully the requirements.
Thanks.