Re:SQLBolt – Interactive lessons and exercises to learn SQL
by rahimnathwani on Thursday July 15, 2021 @10:52AM
(#27845450)
When GP says 'you can use the advanced features', 'you' refers to the person developing the ORM, not to a developer using the ORM.
So the ORM author can do the hard work of allowing advanced features to work across databases. And it's transparent to the developer using the ORM.
I was talking about ORMs in general, not about the programmer in particular. So yes, you are right that if you have enough engineering resources you can support everything. But most ORMs don't help you with this, so it is not a feature of ORMs. You can always bypass it though.
The comparison with JS doesn't fit realy well, because JS is the tool you have to use. You don't have to use ORMs, plain SQL works fine as well.