drizzle-team / drizzle-team/drizzle-orm

[BUG]: aws-data-api driver serializing jsonb to string on read and write paths

Open
#4,701 1 comment 3 reactions 0 assignees View on GitHub
bug
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Report hasn't been filed before.

- [x] I have verified that the bug I'm about to report hasn't been filed before.

### What version of `drizzle-orm` are you using?

0.44.2

### What version of `drizzle-kit` are you using?

0.31.2

### Other packages

drizzle-orm/aws-data-api/pg

### Describe the Bug

- Undesired behavior:
- When querying from an RDS instance using the `aws-data-api/pg` driver, jsonb columns are read as strings, even if they are written as jsonb objects.

- Steps to reproduce:
- Write a jsonb object to the database with a different driver (e.g.) bun-sql, then try to read using the `aws-data-api/pg` driver

- Desired Result:
- Drivers should return jsonb as objects. Drizzle types these jsonb reads as objects, and the driver should respect that.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.