SQL/PGQ: A Systems Perspective
Peter Boncz1,2
1
    VU UNIVERSITY AMSTERDAM, THE NETHERLANDS
2
    CENTRUM WISKUNDE INFORMATICA (CWI), THE NETHERLANDS


                                         Abstract
                                         The main topic the talk is SQL/PGQ, the new sub-language introduced in SQL:2023 for Property Graph
                                         Queries. The talk will cover the history of SQL/PGQ as well as give a short introduction of the syntax
                                         and semantics of this language. The talk will touch upon some research challenges posed by SQL/PGQ
                                         in database architecture (which is my home area), but also in graph algorithms and their complexity.
                                         The talk will also give an update of our effort to implement SQL/PGQ in a real system: namely as an
                                         extension module that will add PGQ support to DuckDB. This system, that was developed in my group at
                                         CWI, is becoming popular for data engineering and data science and I will also talk about opportunities
                                         to integrate PGQ and graph database technology in use cases such as Graph Neural Network training
                                         and scoring.




AMW’23: 15th Alberto Mendelzon International Workshop on Foundations of Data Management, May 22–26, 2023,
Santiago, Chile
Envelope-Open P.Boncz@cwi.nl (P. Boncz)
GLOBE https://homepages.cwi.nl/~boncz/ (P. Boncz)
                                       © 2023 Copyright for this paper by its authors. Use permitted under Creative Commons License Attribution 4.0 International (CC BY 4.0).
    CEUR
    Workshop
    Proceedings
                  http://ceur-ws.org
                  ISSN 1613-0073
                                       CEUR Workshop Proceedings (CEUR-WS.org)