SQL Meets Graph: DuckDB Empowers Seamless Data Exploration
The study introduces a new feature in SQL called SQL/PGQ, which helps make searching through graphs easier by adding new ways to find patterns and paths using SQL queries. The researchers created an extension called DuckPGQ to bring SQL/PGQ into the DuckDB database system, showing how extra capabilities can be added to DuckDB. They improved the system by including new tools for processing data and finding routes efficiently in SQL plans.