duckpgq-extension
duckpgq-extension copied to clipboard
cwida
DuckDB extension that adds support for SQL/PGQ
Similar to being able to import and export a database, a nice to have would be to export and import a property graph and write it to a file for...
Almost all tests seem to fail on Windows in the CI as follows: ```sql ================================================================================ Query unexpectedly failed! (D:/a/duckpgq-extension/duckpgq-extension/test/sql/altering_table.test:34)! ================================================================================ -CREATE PROPERTY GRAPH pg VERTEX TABLES ( Student PROPERTIES (...
Should throw a catalog/Binder exception - [x] #103 - [ ] Column of a table does not exist - [ ] FK of a table does not exist - [...
Many SNB queries such as IC1, IC4, IC5 (see https://github.com/cwida/duckpgq-experiments/issues/26 for all) require optional matches. The PGQ syntax would be `()-[]->?()`. Snippet from the SQL/PGQ specification section 10.6: ``` ::=...
Currently only right-directed edges are allowed to have (un)bounded path patterns. For example: ```sql MATCH o = ANY SHORTEST (a:Person)-[k:knows]->{2,3}(b:Person) ``` The following should also be possible: ```sql MATCH o...
The keyword DEFAULT LABEL is currently not supported. Additionally, the list following LABEL discriminator (labelList) can currently contain duplicate labels. This should not be allowed since all labels should be...
### What happens? see title ### To Reproduce Set `pragma enable_verification` and create a CSR ### OS: macOs 13 - Apple M1 Pro ### DuckDB Version: latest ### DuckDB Client:...
There can only be one `MATCH` statement in a single query. It should be possible to have multiple `MATCH` statements, of which the results can be joined using the cross-product....
-- Preamble: Just stumbled upon the extension, very excited, thank you! Functionality suggestion ( maybe already in pipeline): Explicit graph data are not that common and often have to be...
Fixes #67 and #94. Now bounded length query like: ```sql -FROM GRAPH_TABLE (pg4 MATCH p = ANY SHORTEST (a:Point4)-[k:know4]->{2,3}(b:Point4) COLUMNS (a.id, b.id, vertices(p)) ) tmp; ``` will look for the...
