3 ms·
No, I absolutely don't think so. If you're used to thinking imperatively SQL's declarative approach might seem unfamiliar and somewhat less robust (because you
by BjoernKW 7y ago
No, I absolutely don't think so.
If you're used to thinking imperatively SQL's declarative approach might seem unfamiliar and somewhat less robust (because you don't explicitly tell the machine what to do but to some extent rely on it doing the right thing), even though it's not.
I'd even say that for anything else but trivial queries using an ORM framework tends to be more error-prone than using plain SQL precisely because of the well-known impedance mismatch between the two.
With ORM frameworks more complex queries often can't be expressed as concisely as with SQL, which leads to more code and clumsy work-arounds. More code, in turn means more potential for errors.
- it 7y agoThis has indeed been my own experience. I do wish we could get rid of our ORM and use Postgrest instead but the opinion was put forward that we won't be able to hire people who can write correct SQL.