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