Re: [DISCUSS] CQL handling of WHERE clause predicates

2024-03-26 Thread Jon Haddad
I like the idea of accepting more types of queries with fewer restrictions. I think we've been moving in the right direction, with SAI opening up more types of query possibilities. I think the long term path towards more flexibility requires paying off some technical debt. We have a ton of place

[DISCUSS] CQL handling of WHERE clause predicates

2024-03-26 Thread Benjamin Lerer
Hi everybody, CQL appears to be inconsistent in how it handles predicates. One type of inconsistencies is that some operators can be used in some places but not in others or on some expressions but not others. For example: - != can be used in LWT conditions but not elsewhere - Token expres