B very careful with json and postgressjs, there are strange bugs. Also there are various gotchas on the edges with typescript. AFAIK the code uses a lot of regex and that breaks json in particular.

Uff. Author here. Care to share more? There's no regexp related to json handling, maybe you're thinking of the dynamic query helpers? If not could point to an issue or create one on the repo it'd be great.

This is all very vague and hardly stands up to any kind of scrutiny. Do you have any concrete examples of what you mean?

I've been using postgresjs in production for a while now with jsonb etc... and haven't run into any issues.

What have you seen that's been a problem?

Ever try drizzle?

I haven’t, but it’s an ORM so an automatic no. We tested 6 ORMs before deciding that plain SQL with introspection was the way to go. No regrets.