JSONB content wrongly escaped, leads to DB error on PostgreSQL

[f-jacobi]

Describe the bug When pasting a JSON string in a table field of type JSONB on a PostgreSQL DMBS, Antares adds additional escape characters that result in an invalid input syntax for type json error.

To Reproduce Steps to reproduce the behavior:

1. Have PostgreSQL table with a field of type JSONB, and at least one row/dataset.
2. Edit this table with Antares GUI.
3. Paste the following string in a JSONB field: [{"foo":"bar"}]. Note that it does not matter if you use " or ' for embedded strings.
4. See how Antares replaces " with \" in the console: UPDATE "public"."project" SET "goals" = '[{\"foo\":\"bar\"}]' WHERE "id" = 3
5. See the error message invalid input syntax for type json.

Expected behavior The edited field contains the content [{"foo":"bar"}]

Screenshots

Application (please complete the following information):

• App client PostgreSQL 14.12
• App version 0.7.27
• Installation source: Snap

Environment (please complete the following information):

• OS name: Tuxedo OS
• OS version: 2
• DB name: PostgreSQL
• DB version: 14.12

OS is based on Ubuntu 22.04, KDE plasma 5.27.10

Additional context n/a

[Fabio286]

Hi @f-jacobi, The fix is currently on beta and should be available in next stable release.