CONNECT ENGINE table type=JDBC won't allow spaces in remote column names

When trying to connect to a remote table (in this case the remote server is a MySQL 5.6 server with ANSI qutoes both enabled and disabled during test) any column name with a space in it generates an error as follows:

Got error 174 'ExecuteQuery: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'Provider' in 'field list'' from CONNECT Query is: SELECT `rm_VA_GLOBAL_December2016_CMS_Submission`.`Provider ID`, `rm_VA_GLOBAL_December2016_CMS_Submission`.`Hospital Name`, `rm_VA_GLOBAL_December2016_CMS_Submission`.`Address`, `rm_VA_GLOBAL_December2016_CMS_Submission`.`City`, `rm_VA_GLOBAL_December2016_CMS_Submission`.`State`, `rm_VA_GLOBAL_December2016_CMS_Submission`.`ZIP Code`, `rm_VA_GLOBAL_December2016_CMS_Submission`.`County Name` FROM `rm_VA_GLOBAL_December2016_CMS_Submission` WHERE ( ( TRUE ) AND ( TRUE ) ) LIMIT 0,50