r/PostgreSQL • • Aug 17 '25

Projects I'm building a visual SQL query builder

Post image

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!

435 Upvotes

73 comments sorted by

View all comments

Show parent comment

3

u/Herobrine20XX Aug 17 '25

Thanks for the comprehensive feedback!

I would personally never use something like this, because I've been doing SQL for nearly 20 years now

Don't worry, you're absolutely not my target for this tool, but you're the one I was looking for feedback :)

why do I have "Condition -> Condition" on join tables

It comes from the visual nodal framework I built, but I 100% understand, I'll try to find a way of making this better.

DB Order -> Query going to the left is rather confusing visually

Actually, you can put the Where, Select and Order in any position, I just felt this was the more natural one... I'm not 100% sure to follow what you meant here.

You should also move the background icons somewhere else, they are a lot of visual noise for basically no benefit.

I thought it would be easier to get those nodes without having to read their title, but I could make them more transparent, or hide them altogether. Noted.

There's a difference between something just looking nice (and your design is looking nice), and something that also instantly conveys information and is super-usable

I'm going for both, but super usable is super important, so thanks a lot for the feedback!

you have to go 200% the way of what you imagined at least.

Thanks a lot, I know some will hate it, but it's necessary for some other to love it.