Engine CONNECT doesn't escape table name when autodetecting table structure for TABLE_TYPE=MYSQL using SHOW columns FROM source_table.
That means that following query fails:
Escaping table name within the CREATE doesn't help. The CREATE works, but the engine retrieves data using invalid double escaped query
The create works fine with explicit definition of columns.