Perspective table Query binding MSSQL error

I created a named query and when I run it in the testing area it gives me back the data correctly.
When I want to bind it to a table in perspective it says there is an error next to “FROM” but I don’t understand how there is an error if it works correctly in the named query.

Regardless of the inconsistency, that error is coming from MSSQL/their driver, not Ignition code.

So just if somebody comes around this again. The connection to the datasource was modified with the gateway open. When I closed it and open it again the error was gone, hence the inconsistency.