ALTER TABLE {table_name} RENAME TO {table_name1};

[Vedin]

Such syntax is currently not supported. It's used in some of our SLT tests. Like: join-lateral.slt pivot.slt I don't remember we have plans to add something like this. So, I'd suggest changing tests for now.