Documentation needed for this case:
Select all rows and columns from ‘main’ table joined to related table.
Join is required for ordering and filtering.
Related columns required for building result grid.
I think it’s a pretty common task.
The example I found here produces two queries: one for main table joined with related, and one for related table data, which is a little bit weird to me.