Cannot execute query against a Local Storage table using DECODE function (4265776)

Cannot execute query against a Local Storage table using DECODE function:

select 'table'.field1,
max(decode(field2,'1',field3,'')) as '1',
max(decode(field2,'2',field3,'')) as '2',
max(decode(field2,'3',field3,'')) as '3',
max(decode(field2,'4',field3,'')) as '4',
max(decode(field2,'5',field3,'')) as '5',
from {{table}} 'table'
group by 'table'.field1

Local Storage uses MySQL language.
The Decode function does not exist in MySQL.

Replace DECODE function with the IF function as such:

Select table.Field1,
Max(if(Field2='1',Field3,'')) as '1',
Max(if(Field2='2',Field3,'')) as '2',
Max(if(Field2='3',Field3,'')) as '3',
Max(if(Field2='4',Field3,'')) as '4',
Max(if(Field2='5',Field3,'')) as '5'
FROM table1 GROUP BY table.Field1