Teiid supports multi-line comments enclosed with /* */:

/* comment
comment
comment... */

And single line comments:

SELECT ... -- comment

Comment nesting is supported.