search

cwida / duckpgq-extension

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

Column aliases #25

Closed Dtenwolde closed 2 months ago

Dtenwolde commented 1 year ago

SQL/PGQ allows for every column mentioned in the PROPERTIES (list of columns) to have an alias. This is currently not supported

Adding support for this requires that the PropertyGraphTable->column_names will be slightly different.

For a given case Student PROPERTIES (id AS id_alias), the column id should exist in the table Student

Dtenwolde commented 1 year ago

Technically, aliases could also be used in the except list, but that seems pretty pointless. PROPERTIES ARE ALL COLUMNS EXCEPT (id as alias) At the transformer we currently filter out all columns listed in the except list from all columns of the table. So an alias has no use afaik

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.

Dtenwolde commented 2 months ago

At the moment I don't feel this is necessary to support. If a feature request comes up for this I will take another look. Might also revisit this in the future if I run out of things to do