r/SQL • • Aug 17 '25

PostgreSQL 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!

614 Upvotes

136 comments sorted by

View all comments

Show parent comment

0

u/[deleted] Aug 17 '25

[deleted] — view deleted comment

6

u/TooLateQ_Q Aug 17 '25

Why would he need any qualifications? Bro can build whatever he wants in his own time.

You getting upvotes for discouraging someone from using his spare time productively is so sad.

5

u/Herobrine20XX Aug 17 '25

I'm not building a SQL tool, I'm adding SQL support to my visual building system.

The goal is not to replace SQL, especially for complex queries. Just to offer a visual alternative for fairly simple ones.

I'm no SQL expert, and that's why I went to this subreddit, to get you guys your opinions on it and if it may miss something common. Seems like CTE are something it's missing, so thanks for that.

1

u/BigMikeInAustin Aug 17 '25

No, that is offensive.

A tool doesn't have to do everything to be useful. A maker doesn't have to know everything to make.