If you never used a CTE, maybe… The reason to use SQL is to get what you need out of a database. Performance is orthogonal to that.
replyI’m not sure why you thought I meant code clarity and not performance? It’s clear in all cases the correct SQL query will be more performant.
replyConfused at what you’re evening trying to say here. Are you suggesting that 100 lines of application layer code is easier to understand than 15 lines of SQL?
The correct SQL query will be more performant than what? The correct ORM call will build the same correct SQL query.
replyORM is ultimately SQL
So there is no CPU cycles for the ORM itself? That’s free?
replyIt's 2026. CPU goes brrr. It's absolutely trivial compared to the query execution time.
reply