The DSL is a hash map: it is inherently unordered. There's a :join-by construct in the DSL if you need JOINs in a specific order for your database (the behavior with multiple JOINs differs between databases... because of course it does).

Thanks, I switched to that already. I just wondered if I was missing a trick. I've noticed that hashmaps tend to be ordered by key alphabetically, and since inner-join and join are both ahead of left-join, I was wondering if you were forcing the behaviour for some reason.

Small hash maps stay in key order because they use an array but that's a pure implementation detail and should never be relied on:

user=> {:b 2 :a 1}
{:b 2, :a 1}