Package - Writing Json object back to SQL fails

Hellos,

From URL logger , i recieve a json , which I rework with python , my json is inside formatted_json and I am now trying to write it back to SQL using packag but I keep getting erorr

I swear this was workign fine with 6.4.4.2

UPDATE event_log 
SET text_field_03 = 'formatted_json'
WHERE id = '00cf9c45-e7f7-41aa-99eb-7a21fad4115d';

OR


then i tried below too but no avail 

DECLARE @claude_data NVARCHAR(MAX);
SET @claude_data = JSON_MODIFY('{}', '$', JSON_QUERY(formatted_json));
UPDATE event_log 
SET text_field_03 = @claude_data
WHERE id = '00cf9c45-e7f7-41aa-99eb-7a21fad4115d';

OR
DECLARE @json_data NVARCHAR(MAX) = 'formatted_json';
UPDATE event_log 
SET text_field_03 = @json_data
WHERE id = '00cf9c45-e7f7-41aa-99eb-7a21fad4115d';
 

it might fail if 'formatted_json' variable has some special characters inside for example a singe quote  

Oh , the single quote definitely exists . To write to SQL, I need to encode / escape it with \ ? 

ChatGPT to rescue.

TO escape single quote ' , I did two single quotes ''
The change in my python package was

apps_json = apps_json.replace("'", "''")

Good idea