Feature request: Query builder improvements

[akphi]

Following is a list of query builder improvements and features to be done. Ideally, we should create separate issues when we work on big chunks listed here (e.g. #253, #254)

Context and Motivation

General

• Support viewing element in read-only mode in query builder: maybe we can, and we let people open the element in a modal or so and we let them use the visit element button. The point is we don't require them to leave query builder to visit the elements - Feature request: support viewer mode for query builder #955
• Feature request: Minor improvements to query builder UI/UX (phase 1) #631
• Feature request: Support workflows in query builders #319

Query parameter

• Allow specifying parameter for query (support service use case) (add query builder parameter support #508)
• Feature request: Query parameters support improvements (phase 2) #540

Subtype handling

• Feature request: Handle subtypes in query builder #630

Explorer tree:

• CONSIDER For allow DnD multiple selected items, we need to implement multi drag source in react-dnd - check Support dragging multiple elements react-dnd/react-dnd#14 (comment) AND Dragging multiple selected items react-dnd/react-dnd#1016 (comment)
• Qualified properties modal - Feature request: rework derived property parameters editor #956
  • CONSIDER the explorer on the left, we can add a list/explorer???
  • Show full signature (with paren, types, ...)
  • Potentially introduce color-coding
  • Indent for the param inputs -> i.e. make it look like an actual function
• Property Search - Feature request: Query Builder Property Search #782

Preview data:

• Feature request: Query builder: Previewing data for mapped properties #324

Result Panel

• Improve integration with ag-grid and interact with the grid to edit projection (sorting, column position, pivoting, etc.): we can have a check box Sync table with projection -> when this is on, we will modify the table and the projection at the same time. - Feature request: support using result grid/table to edit query #957

Query Options / Result Set Modifier

• DnD to re-arrange sort columns

Projection

• Feature Request: do validation on query projection columns with duplicated names #626
• Allow deleting projection/graph-fetch node via right-clicking/context-menu
• Feature request: support inline-editing for query's property expressions #959

Filter - #958

• Feature Request: support derivation as LHS for filter, post-filter, aggregation #627
• Feature Request: support more date/time capabilities in query filter #628
• BUG squash node (when deleting) added to the end of list, not in place/ do not respect order
• Rearrange DnD algorithm: prevent drop to children
• Rearrange DnD algorithm: prevent move to itself
• Rearrange DnD algorithm: prevent drop to immediate parent
• Show background when drag is over tree node group
• Show color coding for group on the side of the group when selected (like indent guideline in code editor)
• FANCY while dragging to rearrange, hover over node to open it (~2 seconds) (see VSCode/Macintosh behavior)

Post Filter (TDS Filter)

• Feature request: Post Filter in Query Editor #839

Consider (features we haven't confirmed yet)

• Support fiscal calendar

[akphi]

Close to file smaller issues