SQL Property Graph Queries (SQL/PGQ)

Edit
ID 4904
Title SQL Property Graph Queries (SQL/PGQ)
CI (CFBot) Summary
Stats (from CFBot) Patch count: 5, First patch: +15030−214, All patches: +15261−214
Tags SQL Commands
Created 2024-03-22 13:00:05
Last modified 2026-03-10 13:24:42 (4 days ago)
Latest email 2026-03-11 17:04:38 (3 days ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Ready for Committer
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
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
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
Target version
Authors Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat)
Reviewers Vik Fearing (xocolatl), Zhao Junwang (zhjwpku), Hannu Krosing (hannukrosing), Henson Choi (assam258.gmail.com)Become reviewer
Committer Peter Eisentraut (petere)
Links
Emails
SQL Property Graph Queries (SQL/PGQ)
First at 2024-02-16 14:53:11 by Peter Eisentraut <peter at eisentraut.org>
Latest at 2026-03-11 17:04:38 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest attachment (v20260311_SQL_PGQ.tar.gz) at 2026-03-11 07:34:43 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
    Attachment (v20260311_SQL_PGQ.tar.gz) at 2026-03-11 07:34:43 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v20260306-0002-Simplify-property-not-found-error-message.patch) at 2026-03-06 09:32:32 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20260227-0002-Simplify-property-not-found-error-message.patch) at 2026-02-27 17:06:13 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20260226-0003-Move-GraphTableParseState-to-parsenodes.h.patch) at 2026-02-26 11:06:13 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (nocfbot-0001-Add-BEGIN_CATALOG_STRUCT-END_CATALOG_STRUCT.patch) at 2026-02-25 11:33:58 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20260225-0002-Sort-out-RELKIND_PROPGRAPH-table_open.patch) at 2026-02-25 08:28:21 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20260225-0002-Sort-out-RELKIND_PROPGRAPH-table_open.patch) at 2026-02-25 06:40:55 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (nocfbot-0001-Sort-out-RELKIND_PROPGRAPH-table_open-v2.patch) at 2026-02-19 09:31:22 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (nocfbot-0001-Sort-out-RELKIND_PROPGRAPH-table_open.patch) at 2026-02-18 15:28:02 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20260113-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2026-01-13 16:14:22 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0001-Various-small-updates.patch.nocfbot) at 2026-01-13 10:23:25 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20260109-0003-SQL-PGQ-Support-multi-pattern-path-matching-in-GRAPH.txt) at 2026-01-09 06:53:29 from Henson Choi <assam258 at gmail.com> (Patch: Yes)
    Attachment (v20260102-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2026-01-02 08:48:03 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (valgrind.tgz) at 2026-01-01 06:16:00 from Henson Choi <assam258 at gmail.com> (Patch: No)
    Attachment (coverage.tgz) at 2025-12-31 06:23:13 from Henson Choi <assam258 at gmail.com> (Patch: No)
    Attachment (v20251230-2-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2025-12-30 11:27:15 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v20251230-0002-Fix-some-more-references-and-edit-document.patch) at 2025-12-30 09:44:02 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20251226-0002-SQL-PGQ-Add-PROPERTY_NAMES-graph-element-function.patch) at 2025-12-26 12:33:41 from Henson Choi <assam258 at gmail.com> (Patch: Yes)
    Attachment (v20251225-0001-Add-LABELS-graph-element-function.patch) at 2025-12-24 16:23:11 from Henson Choi <assam258 at gmail.com> (Patch: Yes)
    Attachment (v20251218-0002-create_property_graph-test-changes.patch) at 2025-12-18 09:15:29 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Add-test-for-properties-typmod-mismatch.patch.nocfbot) at 2025-12-17 08:58:22 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v20251217-0002-Edge-in-any-direction-bug.patch) at 2025-12-17 05:32:30 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v20251215-0002-Edge-in-any-direction-bug.patch) at 2025-12-15 13:13:08 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (test2.sql) at 2025-12-13 19:57:56 from Peter Eisentraut <peter at eisentraut.org> (Patch: No)
    Attachment (v20251209-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2025-12-09 10:21:16 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v-20251202-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2025-12-02 10:00:59 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0001-Typos-and-minor-style-fixes.patch.nocfbot) at 2025-11-25 13:52:21 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (order_keyword_fix.diff.txt) at 2025-11-24 05:00:13 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (SQL_PGQ_20251120.zip) at 2025-11-20 15:13:16 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (sql_pgq_one_patch_20250807.zip) at 2025-08-07 10:47:37 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (SQL_PGQ_20250722.zip) at 2025-07-22 11:40:26 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (pg-sql-pgq-20250311-nodups.tar.gz) at 2025-07-06 16:10:47 from Hannu Krosing <hannuk at google.com> (Patch: No)
    Attachment (pg-sql-pgq-20250311.zip) at 2025-03-11 07:21:40 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v14-0011-handle-RTE_GRAPH_TABLE-in-AcquireRewriteLocks.patch) at 2025-03-11 06:06:41 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v12-0010-adapt-property-graph-to-more-intuitive-titles.patch) at 2025-02-26 14:34:38 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v11-0013-refactor-insert_property_record-and-reduce-call-.patch) at 2025-02-23 12:54:53 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v10-0011-do-not-use-default-COLLATE.patch) at 2025-02-10 15:00:05 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (0001-trivial-refactor-of-property-graph-object-address.txt) at 2025-02-06 14:52:32 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (pg_sql_pgq-20250128.zip) at 2025-01-28 10:26:45 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0002-trivial-refactor.patch) at 2025-01-24 15:46:30 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (sql_pgq_patch_set_20250124.zip) at 2025-01-24 13:36:11 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (sql-pgq-2025-01-01.zip) at 2025-01-01 09:01:59 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (0002-support-WHERE-clause-in-graph-pattern-20250101.patch) at 2025-01-01 08:52:29 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Broken-out-tokeniziation-of-arrows.patch) at 2024-12-21 21:45:25 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
    Attachment (v1-0001-fix-wrong-ref-keys.txt) at 2024-12-21 12:51:04 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (0004-Fixes-following-issues-20241205.patch) at 2024-12-05 11:42:11 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-support-WHERE-clause-in-graph-pattern-20241122.patch) at 2024-11-22 13:59:16 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0004-Fixes-following-issues-20241105.patch) at 2024-11-05 15:41:24 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0001-Broken-out-tokeniziation-of-arrows.patch) at 2024-10-29 19:55:25 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
    Attachment (0004-Fix-spurious-column-not-found-error-20240828.patch) at 2024-08-28 10:18:46 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (testcase.sql) at 2024-08-13 10:38:07 from Ajay Pal <ajay.pal.k at gmail.com> (Patch: No)
    Attachment (testcase.sql) at 2024-08-13 09:52:43 from Ajay Pal <ajay.pal.k at gmail.com> (Patch: No)
    Attachment (0003-Fix-compilation-error-20240805.patch) at 2024-08-10 09:21:43 from Imran Zaheer <imran.zhir at gmail.com> (Patch: Yes)
    Attachment (0004-Fix-spurious-column-not-found-error-20240805.patch) at 2024-08-05 12:41:20 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0006-Support-for-EXCEPT-list-in-Labels-and-properties.patch) at 2024-08-04 07:02:07 from Imran Zaheer <imran.zhir at gmail.com> (Patch: Yes)
    Attachment (0002-pgperltidy-fixes-20240722.patch) at 2024-07-22 12:01:42 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0003-Fix-compilation-error-20240717.patch) at 2024-07-17 05:34:48 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (0002-Fix-compilation-error-20240708.patch) at 2024-07-08 13:37:48 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v1-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2024-06-27 12:31:00 from Peter Eisentraut <peter at eisentraut.org> (Patch: No)
    Attachment (0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ-20240305.patch) at 2024-03-05 12:08:30 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: No)
    Attachment (v0-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch) at 2024-02-16 14:53:11 from Peter Eisentraut <peter at eisentraut.org> (Patch: No)
History
When Who What
2026-03-10 13:24:42 Peter Eisentraut (petere) New status: Ready for Committer
2026-03-01 18:24:32 Peter Eisentraut (petere) Added petere as committer
2026-02-25 07:08:32 CFbot Patch does not need rebase anymore
2026-02-11 23:13:27 CFbot Patch needs rebase
2026-02-01 00:00:09 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-01 06:36:27 CFbot Patch does not need rebase anymore
2025-12-31 06:31:25 CFbot Patch needs rebase
2025-12-30 10:10:28 CFbot Patch does not need rebase anymore
2025-12-26 02:57:15 Henson Choi (assam258.gmail.com) Added assam258.gmail.com as reviewer
2025-12-24 16:38:22 CFbot Patch needs rebase
2025-12-15 13:33:28 CFbot Patch does not need rebase anymore
2025-12-15 07:57:24 CFbot Patch needs rebase
2025-12-11 17:04:59 Hannu Krosing (hannukrosing) Added hannukrosing as reviewer
2025-12-03 10:52:27 Peter Eisentraut (petere) Moved from CF PG19-3 to CF PG19-4
2025-12-03 10:52:21 Peter Eisentraut (petere) New status: Needs review
2025-11-20 15:44:31 CFbot Patch does not need rebase anymore
2025-10-20 11:24:55 Peter Eisentraut (petere) Moved from CF PG19-2 to CF PG19-3
2025-09-05 12:41:23 CFbot Patch needs rebase
2025-09-01 10:49:25 CFbot Patch does not need rebase anymore
2025-08-12 06:49:52 Peter Eisentraut (petere) Moved from CF PG19-1 to CF PG19-2
2025-08-06 12:42:26 CFbot Patch needs rebase
2025-06-15 20:07:39 CFbot Patch does not need rebase anymore
2025-04-06 12:24:56 Peter Eisentraut (petere) Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-23 22:47:40 CFbot Patch needs rebase
2025-03-11 07:31:45 CFbot Patch does not need rebase anymore
2025-03-11 04:15:28 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-10 23:33:40 CFbot Patch needs rebase
2025-02-24 14:34:45 CFbot Patch does not need rebase anymore
2025-02-22 10:33:41 CFbot Patch needs rebase
2025-02-04 07:53:08 Ashutosh Bapat (ashutoshbapat) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-22 05:41:12 Zhao Junwang (zhjwpku) Added zhjwpku as reviewer
2024-12-01 14:24:09 Peter Eisentraut (petere) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-25 10:52:23 Vik Fearing (xocolatl) Added xocolatl as reviewer
2024-09-30 19:18:22 Peter Eisentraut (petere) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 05:54:56 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-06-27 12:31:47 Peter Eisentraut (petere) Changed authors to Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat)
2024-03-22 13:00:19 Peter Eisentraut (petere) Changed authors to Peter Eisentraut (petere)
2024-03-22 13:00:05 Peter Eisentraut (petere) Attached mail thread a855795d-e697-4fa5-8698-d20122126567@eisentraut.org
2024-03-22 13:00:05 Peter Eisentraut (petere) Created patch record
Edit