Cross connection database give "An unexpected token... from HUB" error when using WITH statment. (4225814)

In a general non cross-connection environment a WITH statement will run. But in cross connection environment, even if there's only one platform being referenced, it gives the error:

"Got error 4208 '{1677} ODBC data source returned an error: SQL0104N An unexpected token "`" was found following "`' from HUB".

Is WITH supported?

This is a Cross Connection Query Builder and MySQL limitation.

WORKAROUND:

None. WITH is not support in this case.

Cross connection environment is based off MySQL. WITH is not supported by MySQL so there is a limitation on the Toad end also.