DON’T USE YOUR ORM ENTITIES FOR EVERYTHING — EMBRACE THE SQL!

Summary from the TLDR Web Dev newsletter

Object-Relational Mappers (ORMs) are useful tools, but shouldn't be treated as the only way to interact with your database. The belief that ORMs completely eliminate the need to write SQL is misguided - SQL should be used directly to optimize your database interactions. Using techniques like projections that select only the necessary data can improve performance a lot.