Bug: Sort order not preserved in distinct query

[frankdugan3]

Describe the bug

When sorting with distinct, the query builder seems to add an extraneous ORDER BY that conflicts with the specified sort direction.

To Reproduce

query
|> Ash.Query.sort(job_no: :desc)
|> Ash.Query.distinct(:job_no)
|> Ash.Query.limit(20)

SELECT
  DISTINCT ON (e0."job_no") e0."job_no",
  -- ...
  e0."id"
FROM
  "e2_routing" AS e0 WINDOW "order" AS (
    ORDER BY
      e0."job_no" DESC
  )
ORDER BY
  e0."job_no",
  e0."job_no" DESC
LIMIT
  $ 1 [ 20 ]

The query generated without distinct is as expected:

query
|> Ash.Query.sort(job_no: :desc)
|> Ash.Query.limit(20)

SELECT
  e0."job_no",
  -- ...
  e0."id"
FROM
  "e2_routing" AS e0 WINDOW "order" AS (
    ORDER BY
      e0."job_no" DESC
  )
ORDER BY
  e0."job_no" DESC
LIMIT
  $ 1 [ 20 ]

Expected behavior

Sort/direction should be preserved through a distinct query.

** Runtime

• Elixir 1.13.4
• Erlang OTP 24
• OS 5.4.188-1-MANJARO (Linux)
• Ash 1.52.0-rc.1
• ash_postgres 0.42.0-rc.0