Here's an example CQL in the upcoming Teiid 8.7 documentation:
'SELECT firstname, lastname FROM users WHERE birth_year = $1 AND country = $2 ALLOW FILTERING'
ARRAYTABLE(n.tuple COLUMNS firstname string, lastname string)
Can I use regular SQL syntax? Can Teiid transforms regular SQL to CQL and append ALLOW FILTERING?
According to the doc, its done with a direct query. So not sure about using SQL, there's no indication (maybe needing more clarification in the documentation). Here's the draft of 8.7: Cassandra Translator - Teiid 8.7 (draft) - Project Documentation Editor
> Can Teiid transforms regular SQL to CQL and append ALLOW FILTERING?
I'm not sure if it was intentional on the part of the author or the translator or not, but it does not currently have any logic related to ALLOW FILTERING. If it's generally required, then we'll need to add something. But if it's something that can be configured on the driver or server side that will mitigate the need for additional translator logic.