Heavy Hibernate user here, Hibernate does not make it impossible to write N+1 queries afaik - unless there are some tips we're missing in our team?

We just regularly check our slow queries dashboard, fix it (or well let an LLM work on it) and then move on.

I recall hibernate, it maybe rails, as those are my most used tech, that it can detect n+1, and then just query the whole relation.

Detecting is easy if you’re iterating over a proxy collection