Skip to content

ORM: JSON path queries #19

@devituz

Description

@devituz

Goal

Support JSON column path expressions in Where clauses across the three shipped dialects (data->>'name' style on Postgres, JSON_EXTRACT on MySQL/SQLite). Currently raw JSON access needs WhereRaw.

Acceptance criteria

  • q.WhereJSON("data.user.name", "=", "Ada") works on all three drivers
  • Grammar method renders the dialect-correct expression
  • Tests covering each dialect (skip when driver not available)
  • Doc paragraph

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions