Query will work in SQL, but not Knime

Hello! Knime newcomers here hoping the community can help us out with a question.

We have a database query that we have been able to run successfully in SQL, but the query will not run in Knime.

Query structure is as follows:

SELECT [MATERIAL]

,[PLANT]

,[BOM component]

,[BOM Component Description]

,[Item Category]

,[BOM Item Number]

,[Relevant Production]

FROM [DBPartReleaseSQL].[dbo].[DownloadBOM]

where [PLANT] = '929P

Has anyone experienced something like this? Is there anything special we need to do in Knime? Thank you!