I had the same king of problem. I used dynamic SQL to get around this....

I personnally do not know how to limit the syntax validation, sorry.