MySQL UPDATE query does not escape single quotes in existing field

[nicofrand]

Describe the bug

Updating a field that contains a ' fails.

To Reproduce

1. Create database and table with the content below
2. Try to edit the configuration field by setting the value {} (or whatever) as TEXT
3. Wait (even though that should be quick)
4. See error

Expected behavior

No error, and the ' is properly escaped in the UPDATE query.

Screenshots
If applicable, add screenshots to help explain your problem.

Application (please complete the following information):

• App client [e.g. MySQL]
• App version [e.g. 0.5.2]
• Installation source: [e.g. exe, Linux Store, AppImage, dmg]

Environment (please complete the following information):

• OS name: Ubuntu
• OS version 24.10
• DB name MySQL
• DB version 8.0.32

Screenshots

See unescaped single quotes

Additional context

SQL boilerplate:

CREATE TABLE `TestingTable` (
  `configuration` longtext COLLATE utf8mb3_unicode_ci NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

INSERT INTO `TestingTable` (`configuration`) VALUES ('{\"title\": \"Bug à l\'apostrophe\"}');