SimpleSQLite icon indicating copy to clipboard operation
SimpleSQLite copied to clipboard

can not insert JSON data

Open bindi-mo opened this issue 10 months ago • 2 comments

If there is a single quote in the JSON data, it will be enclosed in double quotes, causing a syntax error and making it impossible to insert.

Value.to_query() in query.py

if value.find("'") != -1:
    return f'"{value}"'

What should I do?

bindi-mo avatar Feb 18 '25 11:02 bindi-mo