Teiid supports multi-line comments enclosed with /* */:
/* comment comment comment... */
And single line comments:
SELECT ... -- comment
Comment nesting is supported.