Select properties of children/references

Created by: Henrik tom Wörden

SELECT is a powerful tool to collect data for further processing. However, currently it is only possible to select properties of the records in the result set (suppose you have "houses" in your search result you can get their height: select height from houses). You cannot access properties of records that are referenced (you might get windows of the houses: select window from houses; but there is no select window.height from houses)

This promotes a flat data structure where all relevant attributes are connected to a single Record which stand in contrast to the semantic data model that CaosDB uses.

Thus, I recommend, that it should be possible to select properties of referenced records. A dot notation could be a good option. Example: SELECT window.height FROM house.

Imported comments:

By Timm Fitschen on 2020-07-16T00:29:01.373Z

mentioned in commit 30d3d3d4

By Timm Fitschen on 2020-07-16T00:29:01.265Z

closed via merge request !47 (merged)

By Quazgar on 2020-07-14T17:19:42.318Z

mentioned in merge request !47 (merged)

By Quazgar on 2020-07-14T17:18:12.681Z

See !47 (merged) for an implementation.

By Quazgar on 2020-05-27T13:46:05.263Z

changed the description

By Quazgar on 2020-05-27T13:45:08.032Z

changed the description