SQL:2023 JSON simplified accessor support

Edit
ID 5214
Title SQL:2023 JSON simplified accessor support
CI (CFBot) Summary
Stats (from CFBot) Patch version: v22, Patch count: 5, First patch: +132−7, All patches: +1904−205
Topic SQL Commands
Tags
Created 2024-08-29 16:36:49
Last modified 2025-10-30 13:39:22 (3 hours ago)
Latest email 2025-09-24 06:37:43 (1 month ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
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 19
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-09-24 06:37:43 by Chao Li <li.evan.chao at gmail.com>
Latest attachment (v22-0005-Implement-read-only-dot-notation-for-jsonb.patch) at 2025-09-24 01:05:26 from Alexandra Wang <alexandra.wang.oss at gmail.com>
    Attachment (v22-0005-Implement-read-only-dot-notation-for-jsonb.patch) at 2025-09-24 01:05:26 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v21-0004-Extract-coerce_jsonpath_subscript.patch) at 2025-09-22 17:31:47 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v20-0005-Implement-read-only-dot-notation-for-jsonb.patch) at 2025-09-19 20:40:32 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v19-0005-Implement-read-only-dot-notation-for-jsonb.patch) at 2025-09-15 18:32:52 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v18-0006-Implement-Jsonb-subscripting-with-slicing.patch) at 2025-09-10 23:56:40 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v17-0007-Implement-jsonb-wildcard-member-accessor.patch) at 2025-09-10 16:40:33 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v16-0007-Implement-jsonb-wildcard-member-accessor.patch) at 2025-09-09 15:14:04 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v15-0007-Implement-jsonb-wildcard-member-accessor.patch) at 2025-09-03 02:16:37 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v14-0002-Allow-Generic-Type-Subscripting-to-Accept-Dot-No.patch) at 2025-08-26 03:52:28 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v13-0004-Extract-coerce_jsonpath_subscript.patch) at 2025-08-21 04:53:53 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    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-10-30 13:39:22 Peter Eisentraut (petere) Moved from CF PG19-2 to CF PG19-3
2025-09-12 12:41:40 CFbot Patch does not need rebase anymore
2025-09-11 16:23:23 Alexandra Wang (alexandrawang) Changed targetversion to 19
2025-09-10 17:02:31 CFbot Patch needs rebase
2025-08-21 13:04:48 Jelte Fennema-Nio (jeltef) Moved from CF PG19-1 to CF PG19-2
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