I recently got SQLinForm and love it, its the first time in years I have found a formatter that meets the majority of my requirements, so thank you 🙂
Unless I failed to see it, I believe you should be able to format an update statement in the same manner as a select statement. In particular indenting
The output of my code with current setup
UPDATE tab SET col1 = '1' , col2 = '2' , col3 = CASE WHEN 1 = 1 THEN '3' ELSE NULL END FROM TABLE tab
Â
How I believe i would like it formated
UPDATE tab SET col1 = '1' , col2 = '2' , col3 = CASE WHEN 1 = 1 THEN '3' ELSE NULL END FROM TABLE tab
Â
How a similar select statement formats with my current setup
SELECT col1 , col2 , CASE WHEN 1 = 1 THEN '3' ELSE NULL END FROM TABLE tab
Â
Â
Â