Nice one. How do you decide the difficulty of each problem? One hard problem seemed easy using analytic functions while a medium problem felt hard as it required a self-join the realization of which is the harder part.
How does this compare to react-virtualized (https://github.com/bvaughn/react-virtualized)? Does it handle tables (rendered with table elements and not div)? Does it support column virtual scrolling?
Most of these visual SQL builders I have seen only tackle the basic level of SQL. I am interested in an advanced SQL builder myself to plug as a no-code SQL builder to front the SQL Frames API.
Not sure if your ask is only for open source. I got lucky that my product is JavaScript based and Docusaurus is a perfect way for me to have live interactive docs by using MDX and a wrapper react component. https://sqlframes.com/docs and a quick 5 minute tutorial at https://sqlframes.com/tutorial .
Go to https://sqlframes.com/demo and in the code editor enter the following and execute (this example is taken from the first example on PRQL github page). It generates SQL, but it also computes and displays the results within the browser (though the data set below gives no results).