Generating queries based on abstraction image
We currently help users formulate queries over the data by means of paths only. These are rooted paths (so far) for the XML and CSV data formats.
Instead, it would be more user friendly to provide a graphical query editor that could start from the abstraction image (that is possibly nested).
The first spec would be:
- select an entity to start with
- select either another entity, or an attribute ini another entity
- obtain from the underlying database a path that connects the two (if there are several, ask the user whcih one they want? or ask the user to specify all the intermediary stages?)
- transform the path into an SQL query, evaluate that query (like we already evaluate queries on the graph).