When you use [UseProjection] and the client requests a nested field, HotChocolate generates a .Select() that includes the navigation property. EF Core translates this into a single SQL query with a JOIN: