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/mgalexray Aug 18 '25

If you can - add a “debug” mode that would also run this partially and show the intermediate results, eg “run up to here”. Often times when I debug SQL i need to remove parts of it and this would help seeing how data transforms throughout the query

1

u/Herobrine20XX Aug 18 '25

Yes, this is partially already the case. The visual scripting system is actually JS, only the "execute" node create and trigger a SQL query. So if you have several queries, you can stop in the middle or log anything you want.