[ec109685]

Without two phases: figure out what you need for the resource, execute query, how can you avoid N+1 problem, raw sql or not.

[sgarland]

Recursive CTEs, LEFT JOINs, Stored Procedures…