A query builder is not an ORM.
replyORMs build queries for you, but a query builder does not need to be an ORM.
Autocomplete is making me lazy. If I don't see what I'm about to type within two or three characters, I feel like the IDE isn't doing its job of helping me. So being able to type `db.Cust` and autocomplete Customers is really nice. I do know SQL, but yes, the language servers usually have a harder time connecting the SQL to my backend code, whatever language it's in, without quite a lot of config fiddling that pretty much obviates any time savings I would have gained from autocomplete.
replyIn my database[0] you get an SDK generated from your schema. Typescript is the default and man, the autocomplete works so well.
replyI recently added support for SDK generation in Rust and Go, just do `disc codegen —rust` (double dash, my iPad is autocompleting the wrong dash) and you’re good to go.
[0]: https://disc.sh
I think the bigger problem is that SQL is in almost every language a second-class citizen. And even calling it second-class can be seen as a stretch.
replyI’m a SQL-lover and ORM-hater but I don’t see why any language would support another wholly different language as a first-class citizen.
replyThat's why it's called SQL aka String Query Language. The queries are just strings.
replyAre you being cheeky? The S stands for Structured.
replyWhich is why one is better off using IDEs, especially those from DB vendors.
replyThe problem is that there is no "SQL" — it's different for every database.
replyFor the vast majority of simple use cases the common subset of all popular SQLs is exactly the same. Otherwise… just use Postgres
replydeleted
replyIt's not that different. I'd rather have a different way to do UPSERTs or a different window function here and there [1] than figure out every ORM's join syntax or its sneaky ways to SELECT N+1 me into oblivion.
reply[1] LLMs make these very easy to handle.
I would argue that is a bit like complaining there is no "backend language" and that Java, Rust, Go all have different syntax.
replyThe choice of DB is arguably more important than the choice of backend language.
[dead]
reply