Mule 4 - Convert Array of strings to single string

You can use the joinBy function and then prepend and append the quote and parenthesis.

%dw 2.0
output application/json
var ids = ["1234-114600000034-000093-ABCDE","1234-034-114600000378-FGH",
    "1234-114600000034-1146000-JKLMN","1234-1146034-00380-OPQRS",
    "1234-114600000034-1181-TUVWX"]
---
"UPDATE [TABLE_NAME] SET [COLUMN_NAME] = 1 WHERE ID IN ('" 
    ++  (ids joinBy  "','") ++ "')"

One of the ways to do so could be using reduce.

Script

%dw 2.0
output application/java
var inp = ["1234-114600000034-000093-ABCDE","1234-034-114600000378-FGH","1234-114600000034-1146000-JKLMN","1234-1146034-00380-OPQRS","1234-114600000034-1181-TUVWX"]
---
('(' ++ (inp reduce ((item, acc = '') -> acc ++ "'" ++ item ++ "',"  )) ++ ')') replace ',)' with ')'

Output

('1234-114600000034-000093-ABCDE','1234-034-114600000378-FGH','1234-114600000034-1146000-JKLMN','1234-1146034-00380-OPQRS','1234-114600000034-1181-TUVWX')