cwida / duckpgq-extension

DuckDB extension that adds support for SQL/PGQ
https://duckpgq.notion.site/b8ac652667964f958bfada1c3e53f1bb?v=3b47a8d44bdf4e0c8b503bf23f1b76f2
MIT License
77 stars 7 forks source link

Altering existing property graph syntax #43

Open Dtenwolde opened 1 year ago

Dtenwolde commented 1 year ago

This issue gathers some syntax ideas to alter an existing property graph.

This is specified in the SQL/PGQ standard: 11.20 <alter property graph statement> Please double-check that the proposed queries here adhere to the standard before implementing this.

ALTER PROPERTY GRAPH <property_graph> ADD VERTEX TABLES (CUSTOMER) 
ALTER PROPERTY GRAPH <property_graph> ADD EDGE TABLES (KNOWS, STUDIES_AT)
ALTER PROPERTY GRAPH <property_graph> ADD VERTEX TABLES (CUSTOMER) EDGE TABLES (KNOWS, STUDIES_AT)
ALTER PROPERTY GRAPH <property_graph> DROP VERTEX TABLES (CUSTOMER)
ALTER PROPERTY GRAPH <property_graph> <table_name (or label?)> ADD PROPERTIES (name)
ALTER PROPERTY GRAPH <property_graph> <table_name (or label?)> DROP PROPERTIES (name)
ALTER PROPERTY GRAPH <property_graph> <table_name (or label?)> RENAME LABEL <new_label>
github-actions[bot] commented 2 months ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.