SQL Property Graph Queries (SQL/PGQ)

Edit
ID 4904
Title SQL Property Graph Queries (SQL/PGQ)
CI (CFBot) Summary
Stats (from CFBot) Patch count: 12, First patch: +10924−206, All patches: +13960−214
Topic SQL Commands
Tags
Created 2024-03-22 13:00:05
Last modified 2025-12-03 10:52:27 (50 minutes ago)
Latest email 2025-11-26 03:02:44 (1 week ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Needs review
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)Become reviewer
Committer
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 2025-12-02 10:00:59 by Ashutosh Bapat <ashutosh.bapat.oss at gmail.com>
Latest 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>
    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
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