SQL:2023 JSON simplified accessor support

Edit

5214

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v12, Patch count: 7, First patch: +28−18, All patches: +2066−248

Topic

SQL Commands

Tags

Created

2024-08-29 16:36:49

Last modified

2025-03-20 14:19:24 (4 months ago)

Latest email

2025-07-11 05:53:52 (1 month ago)

Status

PG19-1 (2025-07-01 - 2025-07-31): Needs review

2025-03 (2025-03-01 - 2025-04-08): Moved to different CF

2025-01 (2025-01-01 - 2025-01-31): Moved to different CF

2024-11 (2024-11-01 - 2024-11-30): Moved to different CF

2024-09 (2024-09-01 - 2024-09-30): Moved to different CF

Target version

Authors

Alexandra Wang (alexandrawang)

Reviewers

Peter Eisentraut (petere), Vik Fearing (xocolatl), Jelte Fennema-Nio (jeltef)Become reviewer

Committer

Links

Emails

SQL:2023 JSON simplified accessor support: First at 2024-08-29 16:33:28 by Alexandra Wang <alexandra.wang.oss at gmail.com>
Latest at 2025-07-11 05:53:52 by jian he <jian.universality at gmail.com>
Latest attachment (v12-0001-minor-refactor-based-on-v12_0001_to_0006.no-cfbot) at 2025-07-11 05:53:52 from jian he <jian.universality at gmail.com>
    Attachment (v12-0001-minor-refactor-based-on-v12_0001_to_0006.no-cfbot) at 2025-07-11 05:53:52 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v12-0001-minor-refactor-coerce_jsonpath_subscript.no-cfbot) at 2025-07-10 08:53:28 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v12-0006-Implement-Jsonb-subscripting-with-slicing.patch) at 2025-07-09 08:01:45 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v11-0001-refactoring-v11_01-to-v11_06.no-cfbot) at 2025-06-27 02:09:28 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v11-0001-misc-refactoring-SubscriptingRef-deparsing.no-cfbot) at 2025-06-25 07:40:50 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v11-0001-misc-refactoring-based-on-v11_01_to_06.no-cfbot) at 2025-06-25 05:56:51 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v11-0002-Allow-Generic-Type-Subscripting-to-Accept-Dot-No.patch) at 2025-03-13 14:02:06 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v10-0004-Extract-coerce_jsonpath_subscript.patch) at 2025-03-03 20:22:49 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v9-0003-Export-jsonPathFromParseResult.patch) at 2025-02-27 23:23:30 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v8-0002-Pass-field-accessors-to-generic-subscripting.patch) at 2025-02-27 15:46:48 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Pass-field-accessors-to-generic-subscripting.patch) at 2025-02-05 13:39:15 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (0001-WIP-Operator-apporach-JSONB-dot-notation.txt) at 2025-02-05 07:20:30 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Allow-transformation-only-of-a-sublist-of-subscri.patch) at 2024-11-20 00:06:16 from Nikita Glukhov <glukhov.n.a at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Add-JSON-JSONB-simplified-accessor.patch) at 2024-11-07 21:57:58 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v4-0001-make-simplified-accessor-works-with-domain-ove.no-cfbot) at 2024-10-04 12:33:07 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-JSON-JSONB-simplified-accessor.patch) at 2024-09-26 15:45:11 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Add-JSON-JSONB-simplified-accessor.patch) at 2024-09-23 19:22:20 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Transform-JSON-dot-access-to-arrow-operator.txt) at 2024-08-29 16:33:28 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)

History

When	Who	What
2025-08-14 11:32:46	Jelte Fennema-Nio (jeltef)	Added jeltef as reviewer
2025-03-20 14:19:24	Peter Eisentraut (petere)	Closed in commitfest 2025-03 with status: Moved to next CF
2025-02-11 11:28:50	Vik Fearing (xocolatl)	Added xocolatl as reviewer
2025-02-05 07:21:30	Alexandra Wang (alexandrawang)	New status: Needs review
2025-02-01 20:40:32	Peter Eisentraut (petere)	Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-01 14:41:16	Peter Eisentraut (petere)	New status: Waiting on Author
2024-12-01 14:34:33	Peter Eisentraut (petere)	Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-01 15:49:05	Peter Eisentraut (petere)	Closed in commitfest 2024-09 with status: Moved to next CF
2024-10-01 15:32:02	Peter Eisentraut (petere)	Added petere as reviewer
2024-08-30 06:25:44	Peter Eisentraut (petere)	Changed targetversion to 18
2024-08-29 16:38:21	Alexandra Wang (alexandrawang)	Changed authors to Alexandra Wang (alexandrawang)
2024-08-29 16:38:21	Alexandra Wang (alexandrawang)	Changed targetversion to 17
2024-08-29 16:36:49	Alexandra Wang (alexandrawang)	Attached mail thread CAK98qZ1JNNAx4QneJG+eX7iLesOhd6A68FNQVvvHP6Up_THf3A@mail.gmail.com
2024-08-29 16:36:49	Alexandra Wang (alexandrawang)	Created patch record

Edit