[BUG]: Drizzle reformating JSON values ending up in Postgres unable to parse it

[xegulon]

What version of drizzle-orm are you using?

0.28.6

What version of drizzle-kit are you using?

No response

Describe the Bug

The bug is the one mentionned here: https://stackoverflow.com/questions/77068776/postgres-error-22p02-escape-sequence-e-is-invalid

Before inserting an object with a field that is an array of strings (or an array of json), drizzle seems to be formatting the data, which ends in Postgres being unable to parse it correctly.

There was a similar issue in node-postgres, which seems to have been resolved.

Thanks guys for the amazing work and pleasure to use Drizzle ORM <3

Expected behavior

I would expect Drizzle not to reformat my data badly :)

Environment & setup

Linux. I use Drizzle in conjunction with @vercel/postgres.
When using a raw query with @vercel/postgres to insert my data, I have no problem.

[MHB2011]

I have the same problem. Any solutions other than using raw sql ?

[jkcorrea]

@xegulon @MHB2011 fix is here #666 (comment)

[Angelelz]

This issue is related to #1511. I'll close this one in favor of that one because there of the discussion over there. I'll work on this pretty soon.