Combination queries and loads issue

[rellen]

Versions

Elixir 1.18.3
OTP 27
AshPostgres 2.6.9

Operating system

MacOS

Current Behavior

We have a codebase where a combination query that includes a load is dropping any global sort (i.e. it doesn't have the final outer ORDER BY but to query does return the data we expect (just in the wrong order). I think I've been able to reproduce this bug in the following PR

#586

Reproduction

#586

Expected Behavior

No ecto errors and the final ORDER BY is added to the SQL.