{"doi":"10.14778/3611540.3611614","title":"DuckPGQ: Bringing SQL/PGQ to DuckDB","abstract":"<jats:p>We demonstrate the most important new feature of SQL:2023, namely SQL/PGQ, which eases querying graphs using SQL by introducing new syntax for pattern matching and (shortest) path-finding. We show how support for SQL/PGQ can be integrated into an RDBMS, specifically in the DuckDB system, using an extension module called DuckPGQ. As such, we also demonstrate the use of the DuckDB extensibility mechanism, which allows us to add new functions, data types, operators, optimizer rules, storage systems, and even parsers to DuckDB. We also describe the new data structures and algorithms that the DuckPGQ module is based on, and how they are injected into SQL plans.</jats:p>\n          <jats:p>While the demonstrated DuckPGQ extension module is lean and efficient, we sketch a roadmap to (i) improve its performance through new algorithms (factorized and WCOJ) and better parallelism and (ii) extend its functionality to scenarios beyond SQL, e.g., building and analyzing Graph Neural Networks.</jats:p>","journal":"Proceedings of the VLDB Endowment","year":2023,"id":20214,"datarank":0.5401208886195608,"base_score":2.1972245773362196,"endowment":2.1972245773362196,"self_citation_contribution":0.32958368660043297,"citation_network_contribution":0.21053720201912776,"self_endowment_contribution":0.32958368660043297,"citer_contribution":0.21053720201912776,"corpus_percentile":null,"corpus_rank":null,"citation_count":8,"citer_count":8,"citers_with_citation_signal":7,"citers_with_endowment":7,"datacite_reuse_total":0,"is_dataset":false,"is_dataset_confidence":null,"is_data_producer":false,"deposit_databanks":null,"is_oa":false,"file_count":0,"downloads":0,"has_version_chain":false,"published_date":null,"fair_score":null,"fair_percentile":null,"algorithm_id":"datarank_citation_only_1hop_v6","ranking_scope":"data_only","authors":[{"id":134398,"name":"Gábor Szárnyas","orcid":null,"position":1,"is_corresponding":false},{"id":134399,"name":"Peter Boncz","orcid":null,"position":2,"is_corresponding":false},{"id":134397,"name":"Daniel ten Wolde","orcid":null,"position":0,"is_corresponding":false}],"reference_count":0,"raw_metadata":{"has_enrichment":true,"base_score":2.1972245773362196,"endowment":2.1972245773362196,"datacite_reuse_total":0,"file_count":0,"downloads":0,"views":0,"has_version_chain":false,"is_dataset":false,"is_oa":false,"pmid":"24259432","pmcid":null,"openalex_id":"https://openalex.org/W4386768611","authors":[],"funders":[],"total_grants":0,"fwci":1.5367,"citation_percentile":0.83967495,"influential_citations":1,"citation_trend":[{"year":2023,"count":1},{"year":2024,"count":3},{"year":2025,"count":4}],"oa_status":"closed","license":null,"oa_locations":[{"url":"https://dl.acm.org/doi/pdf/10.14778/3611540.3611614","host_type":"publisher"},{"url":"https://doi.org/10.14778/3611540.3611614","host_type":"journal"},{"url":"https://ir.cwi.nl/pub/33317","host_type":"repository"}],"fields_of_study":["Advanced Database Systems and Queries","Data Management and Algorithms","Semantic Web and Ontologies","Computer Science"],"mesh_terms":[],"keywords":["Computer science","SQL/PSM","SQL","Data definition language","Stored procedure","PL/SQL","Language Integrated Query","Programming language","Query by Example","Data Transformation Services","SQL injection","User-defined function","Parsing","Autocommit","Database","Information retrieval"],"sdg_mappings":[],"linked_datasets":[],"clinical_trials":[],"software_tools":[],"database_accessions":[],"source":"live","citation_network_status":"fetched"},"created_at":"2026-06-04T07:46:47.949974Z","pmid":null,"pmcid":null,"fwci":null,"citation_percentile":null,"influential_citations":0,"oa_status":null,"license":null,"views":0,"total_file_size_bytes":0,"version_count":0,"fair_f":null,"fair_a":null,"fair_i":null,"fair_r":null,"fair_zscore":null,"fair_rationale":null,"fair_model":null,"fair_agent_version":null,"fair_fulltext_source":null,"fair_has_llm":null,"fair_computed_at":null,"clinical_trials":[],"software_tools":[],"db_accessions":[],"linked_datasets":[],"topics":[]}