Feature Request: DuckDB UI and instant pgq

[hpvd]

duckdb and motherduck just introduced

• duckdb local ui see https://duckdb.org/2025/03/12/duckdb-ui.html
• with instant sql see https://motherduck.com/blog/introducing-instant-sql/

=> would be awesome to make the same possible for pgq in duckdb

Reasons:

• full integration/first class citizen of graph data
• consistency to duckdb experience
• speed of data inside

[Dtenwolde]

Hi there, I think this would be really cool to support, but I am not in control of the DuckDB UI. Perhaps it's worth a shot to open an issue over at https://github.com/duckdb/duckdb-ui and see what their response is. Please tag me in the issue, I'd be curious to follow :)

[hpvd]

here you go duckdb/duckdb-ui#137

[Dtenwolde]

Just as an update, it seems from trying out a bit that you get a syntax error at "MATCH", in the following query:

ATTACH 'https://github.com/Dtenwolde/duckpgq-docs/raw/refs/heads/main/datasets/snb.duckdb';

use snb;
install duckpgq from community; 
load duckpgq;

CREATE or replace PROPERTY GRAPH snb
VERTEX TABLES (
  Person, Forum
)
EDGE TABLES (
  Person_knows_person     SOURCE KEY (Person1Id) REFERENCES Person (id)
                          DESTINATION KEY (Person2Id) REFERENCES Person (id)
                          LABEL knows,
  Forum_hasMember_Person  SOURCE KEY (ForumId) REFERENCES Forum (id)
                          DESTINATION KEY (PersonId) REFERENCES Person (id)
                          LABEL hasMember
);


-- Find mutual friends between two users
FROM GRAPH_TABLE (snb
  MATCH (p1:Person WHERE p1.id = 16)-[k:knows]->(p2:Person)<-[k2:knows]-(p3:Person WHERE p3.id = 32)
  COLUMNS (p2.firstName)
);