Comment by HelloNurse
15 hours ago
Even wilder:
> SQL was not designed for application development, and every attempt to integrate it into higher level programs (ORM, fluent query builders, raw strings, macros/preprocessors) comes with unpleasant rough edges.
Forgetting that interactive SQL queries, and to an even greater degree the underlying databases, are applications.
Anyone who hates SQL typically is completely clueless how hard it is to actually do what SQL does correctly and efficiently.
SQL makes doing something that is VERY hard stupidly easy.
The issue is that most of these tools try to reinvent the wheel. Instead of using sql, you use 'fluent builders' or whatever, and they have their own tricks and cevats.
Sqlc is the best thing I've personally used because it produces models and repositories based on plain sql queries.
It's much easier to reinvent one of the most used tools in the world as a far worse version than better.
It's almost as if it was easy to reinvent something highly used that someone would've already done it...