I would expect to be able to use ' and " interchangeably to surround RHS string arguments.
Python dse driver version 2.2.0
This issue was originally reported by Jon Moses as part of an internal UX ticket (UX-34). We're moving all product-related UX tickets to their relative product boards, thus it is here. Jon wasn't sure whether this issue had already been resolved or not.
If I understand you correctly, this is a limitation of CQL, not of the driver – hence the SyntaxException from the server. More generally, the drivers don't parse CQL, they just send it to nodes – so, errors of the class "Session.execute doesn't support <CQL feature>" shouldn't happen with any driver.
I agree with you that this is a CQL misfeature though :/ Sorry I can't be of help there.
Ping for any followup. Any issues with ^, Jon?
No, that makes sense.