The Trino part of this application should get a second tab in which the user can create a query visually instead of needing to type in the correct syntax into the query editor. The design follows the pattern of SvelteFlow with a likeness of ER-diagrams but because there are no foreign keys in Trino, we can't actually display connections automatically between tables.
- The user should be able to add nodes which are connected by edges going from specific columns into a node (e.g.
WHERE, ORDER BY, JOIN etc.).
- The user should be able to save and load queries.
- The user should see the actual query being built in real time.
- For easier access, a simplified inline notation is used to quickly add clauses right under a column via right click.
- Because of the complexity, only one query is allowed to be assembled at a time. This allows us to avoid adding a
SELECT node by moving the selected columns to checkboxes near the individual columns.
The Trino part of this application should get a second tab in which the user can create a query visually instead of needing to type in the correct syntax into the query editor. The design follows the pattern of SvelteFlow with a likeness of ER-diagrams but because there are no foreign keys in Trino, we can't actually display connections automatically between tables.
WHERE,ORDER BY,JOINetc.).SELECTnode by moving the selected columns to checkboxes near the individual columns.