Hacker News new | ask | show | jobs
by dirslashls 1496 days ago
Nice work and great use of React Flow.

What level of sophisticated queries can be created with it? For example, can it do "Top N and Other"? Which BTW, was recently added for SQL Frames ( https://sqlframes.com/docs/data_sets/top_n_other_sets )

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.
1 comments
craftsquick 1496 days ago
You should be able to build every SQL query with this. I built an example Top-N query here: https://imgur.com/a/2xKLltl

Right now building Top-N (and my example) assumes you know the rank function exists, but over time it should be easy enough to pre-build "nodes" that do things like this automatically :)

link