I’m using the Paginator library and right before calling Repo.paginate(), I print the query which is:

Query: #Ecto.Query<from c0 in Amplify.Models.ContestEntry,
 where: c0.contest_id == ^"2", where: not is_nil(c0.prize_id),
 order_by: [desc: c0.inserted_at]>

This makes sense to me, but when I call paginate, it executes:

SELECT ... 
FROM "contest_entries" AS c0 
WHERE (c0."contest_id" = $1) AND (NOT (c0."prize_id" IS NULL)) AND (c0."inserted_at" < $2) 
ORDER BY c0."inserted_at" LIMIT $3 [2, ~U[2024-09-26 19:10:25Z], 4]

Notice that the executed ORDER BY does not have the DESC associated with it.

Could this be because I am passing before to paginator and it defaults to an ASC sort in that case when I really want a DESC sort? If so, how does Paginator handle traversing through a list sorted in reverse?