SQL Update case clause support by jOOQ

Question

Please advise if there is a support for case clause in SQL update statement by jOOQ library? https://www.jooq.org/ I mean what would be the equivalent for

UPDATE TABLE1 SET status = case 
            when status = 'status1' then 'status2'
            when status = 'status2' then 'status3'
            end

I saw examples for select statement in their tutorial but non for update unfortunately. Could it be something like?

DSL.update(DSL.table("table1")).set(DSL.field("status"), DSL.case(...))

user_521799 · Answer

Luckily, there's no difference between SELECT or UPDATE statement support in jOOQ with respect to how arbitrary column expressions are dealt with. Hence, you will just use the CASE expression support in your statement.

You can create a CASE expression using DSL.case_() or DSL.when() directly.

SQL Update case clause support by jOOQ

1 Answers