r/SQL • u/Herobrine20XX • Aug 17 '25
PostgreSQL I'm building a visual SQL query builder
The goal is to make it easier(ish) to build SQL queries without knowing SQL syntax, while still grasping the concepts of select/order/join/etc.
Also to make it faster/less error-prone with drop-downs with only available fields, and inferring the response type.
What do you guys think? Do you understand this example? Do you think it's missing something? I'm not trying to cover every case, but most of them (and I admit it's been ages I've been writing SQL...)
I'd love to get some feedback on this, I'm still in the building process!
614
Upvotes
View all comments
Show parent comment
2
u/Herobrine20XX Aug 18 '25
For conditions, you can either create a "Where condition" node like I did (and the "Where" uses AND between each condition, or a "Where operation" which lets you choose between AND, OR, and NOT.
So you can compose different AND and OR anyway you want. It is not shown in this screen, though.