JSON_QUOTE

1
SELECT
2
  JSON_QUOTE('Hello World') as simple,
3
  JSON_QUOTE('Line1\nLine2') as with_newline,
4
  JSON_QUOTE('Say "Hello"') as with_quotes;

1
SELECT
2
  '{"name": ' || JSON_QUOTE(name) || ', "city": ' || JSON_QUOTE(city) || '}' as json_str
3
FROM users;

1
SELECT
2
  original,
3
  JSON_QUOTE(original) as quoted
4
FROM (
5
  SELECT 'Tab:\there' as original UNION ALL
6
  SELECT 'Path: C:\\Users' UNION ALL
7
  SELECT 'JSON: {"key": "value"}'
8
);