ORMs "kind of" opinionated?

By default, most dictate attribute name case, punctuation, default vs automatically assigned vs required values, validation, etc.

Re: "it's not hard to use it right", and who decides what's right? If you're willing to accept what ORM sh*ts out outta the box, awesome. But if you want to do what an experienced architect (me) knows is right, prepare to spend a LOT of time figuring out how to turn off and/or work around what this "soft of" opinionated, completely opaque demon wants to do.

For the record, "abstracting" oneself from SQL is the first step on the path to ignoring it entirely. Of course, as you correctly point out, you can't just do anything you want (close, but not ANYTHING), but from the abstracted perspective of most developers, it's not clear that what they're trying to do is ridiculous and bizarre until the ORM can no longer figure out some tortured, non-performant way to make it work.

I'm not sure where you came up with putting business logic in the database, which I've been adamantly against since I started designing and building systems almost 30 years ago. That's a complete non sequitur and not something I've EVER done or condoned.

This looks more like (intentionally?) misunderstanding my points and defending rather than questioning the status quo than anything else.