duckpgq-extension icon indicating copy to clipboard operation
duckpgq-extension copied to clipboard

Column aliases

Open Dtenwolde opened this issue 2 years ago • 1 comments

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 avatar Feb 16 '23 10:02 Dtenwolde

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

Dtenwolde avatar Feb 22 '23 15:02 Dtenwolde

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.

github-actions[bot] avatar Sep 07 '24 00:09 github-actions[bot]

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

Dtenwolde avatar Sep 07 '24 20:09 Dtenwolde