Skip to content

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

@sweetro

Description

@sweetro

Report hasn't been filed before.

  • 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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions