Skip to content

Support tuple/composite field access and ARRAY subscripts in expressions #19

Description

@renecannao

From corpus testing against CockroachDB's 3,191 parser test queries (36 PARTIAL results):

Tuple field access (PostgreSQL/CockroachDB):

  • SELECT (i.keys).col — composite type field access
  • SELECT (i.keys).* — composite type wildcard
  • SELECT (expr).@N — CockroachDB ordinal access

Tuple literals:

  • SELECT (1, 2, 3) — row constructor
  • SELECT ((1, 2, 3) AS a, b, c) — labeled tuple

ARRAY subscripts:

  • SELECT (ARRAY['a', 'b'])[2] — array element access

These are valid PostgreSQL syntax used by ORMs and application code. Priority: medium.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    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