I have a remote connection into a mysql database from Redshift. Mysql table has a column year_month which is a reserved word in mysql and since this table is already populated and applications are using it, column name cannot be changed.
I tried backtick, double quotes - both are failing.
select id, `year_month` from updoc_mysql.apsetup;