Some backend libraries let you write SQL queries as they are and deliver them to the database. They still handle making the connection, pooling, etc.
ORMs introduce a different API for making SQL queries, with the aim to make it easier. But I find them always subpar to SQL, and often times they miss advanced features (and sometimes not even those advanced).
It also means every time I use a ORM, I have to learn this ORM's API.
SQL is already a high level language abstracting inner workings of the database. So I find the promise of ease of use not to beat SQL. And I don't like abstracting an already high level abstraction.
Alright, I admit, there are a few advantages:
- if I don't know SQL and don't plan on learning it, it is easier to learn a ORM
- if I want better out of the box syntax highlighting (as SQL queries may be interpreted as pure strings)
- if I want to use structures similar to my programming language (classes, functions, etc).
But ultimately I find these benefits far outweighed by the benefits of pure sql.
I wish we had a nice tagging system (and I don't think they should be hashtags) that was also in common use.
I want to be able to search any post related a certain topic, and sometimes, these may not always be in that topic's community, because topics can overlap. For example, I might want to read posts about Ukraine war, but those might be in world news, US news, or combat footage communities. Could be a community about Ukraine in general, or Ukraine war specifically.
I also may not want to get it from a single Ukraine community. Maybe by finding posts with the "Ukraine war" tag, I'll see several communities and join the one I want. But there needs to be a way to group them somehow.
Such a tag system may be useful for combined topics. For example, I may want to look for posts about music software. They might not be common in the music community, or software communities. But I could filter by both tags and find what I want.