While my article reads like an anti-ORM manifesto, my warning is about relying on ORMs to do all the work. How am I supposed to understand advanced fine-tuning options if I do not understand how the low-level query works?

Copilot may be your little helper in writing code, but it is not going to consistently write the best code that YOU can write.