No-code Chart/Dataset Builder

[nadavgross]

Objective

Introduce a user-friendly, no-code "Query Builder" feature in Apache Superset to simplify the process of creating new datasets and charts for users who are not proficient in SQL.

Rationale

We have numerous clients who possess deep knowledge of their business logic but lack SQL proficiency. This often results in difficulties when they need to create new datasets or charts in Superset.
By implementing a "Query Builder" interface, we aim to:

• Empower users to create datasets and charts without requiring SQL knowledge.

• Streamline the dataset creation process, reducing the dependency on technical users.

Feature Description

The proposed "Query Builder" will be a visual interface integrated within the Superset UI, allowing users to build queries through intuitive form-based inputs.
Key functionalities include:

• Visual Interface: An intuitive interface where users can select tables, columns, and define relationships and joins.
• Form-Based Inputs: Options to filter data, aggregate values, and specify sorting criteria using simple forms and dropdown menus.
• Join Capabilities: Allow users to create joins between tables by selecting the columns to join on and specifying the type of join (e.g., inner join, left join).
• Real-Time Preview: Display a live preview of the resulting dataset based on the current query configuration.
• Chart Integration: Directly link the created dataset to chart types, enabling immediate visualization without additional steps.

Adding a link to a thread I had in slack if anybody needs further information.