Hello, so the SQL Lab is getting interesting, but it's still a very technical tool. I come from the word of Alteryx where people can program visually and it works very well with business users. Also, for technical users visual programming can be faster than coding.
Alteryx and other ETL tools do a lot of things, but I was thinking as a first step a visual SQL query builder would be a good start, this is how it looks: [image: Inline image 2] I have some ideas on how to implement this, but I am looking for either collaborators and/or mentors. I was thinking to implement this as a separate flask app initially to test the concept. The tools up there in the screenshot can basically be represented in a python dictionary which can then be saved in yaml or other. The SQL work can be done leveraging SQL Alchemy. We can decide either to generate SQL code or to generate a yaml file and execute the yaml. The way the process would work would be: - All data is in 1 database cluster - Users can access the data - Users do visual joins, sum, unions, formulas and filters - The compiled data is saved back into the database cluster as a new table - The new table becomes a slice into Superset for dashboards and reports Regards, Alessio
