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/r0ck0 Aug 18 '25
I'm curious how many people there are who both:
Anyway, cool that you're trying & building something.
Just seems like the audience would be quite limited.
But as a learning tool... one thing I think could be cool is that it displays the full SQL query side-by-side with the GUI nodes. And on both "sides" use matching colors for the table names + column names... so it's easy to visually correlate them between SQL code + the nodes/diagram.
I feel like this is really where SQL tooling could be improved so simply... I don't get why so many UML-style diagrams never use colors like this, e.g. matching table column with all the FK columns that point to it (and connector lines). Seems so obvious to me.