5 ms·
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 rec
by dirslashls 4y 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 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.
- craftsquick 4y agoYou should be able to build every SQL query with this. I built an example Top-N query here: https://imgur.com/a/2xKLltl 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 :)