SELECT MULTI IF(age < 18, 'Minor', age < 30, 'Young Adult', age < 40, 'Adult', 'Senior') AS age group

SELECT MULTI IF(age < 18, 'Minor', age < 30, 'Young Adult', age < 40, 'Adult', 'Senior') AS age group: a task in LegoFlow-SWE (Harbor dataset). SeaTunnel's transform-v2 SQL transform does not currently support a MULTI IF function, but users need it to express multi-branch conditional logic in a…