Sorry, I don't understand your question. Is it producing SQL you didn't expect?

Hello Sean, I expect the case be converted to

CASE WHEN (source > destination) THEN sort_order + 1 ELSE sort_order - 1 END

I don't how to write it to have the output

I still don't understand. What does it produce? And why is what it produces not correct for you?

Sorry to not be clear. How can I use the :case to produce a case for set sort = ?

I have the query in string format, and I'm trying to convert it to honeysql

What did you try and what did it produce?

user=> (sql/format {:update :table :set {:source [:case [:> :source :destination] (sql/call :+ :sort-order 1) :else (sql/call :+ :sort-order 1)]}})
["UPDATE table SET source = CASE WHEN source > destination THEN sort_order + ? ELSE sort_order + ? END" 1 1]
user=>

That's with HoneySQL v2 -- although it could be written without sql/call now:

user=> (sql/format {:update :table :set {:source [:case [:> :source :destination] [:+ :sort-order 1] :else [:+ :sort-order 1]]}})
["UPDATE table SET source = CASE WHEN source > destination THEN sort_order + ? ELSE sort_order + ? END" 1 1]
user=>

I basically typed what you wrote into a REPL @U0YJJPFRA

thank you