> > > *I propose that we adopt `ORDER BY` syntax, supporting it for vector > indexes first and eventually for all SAI indexes. So this query would > become SELECT id, start, end, text FROM > {self.keyspace}.{self.table} ORDER BY embedding ANN OF %s LIMIT %s* >
LGTM. I first stumbled a bit with "there's no where clause and no filtering allowed…" But I doubt that reaction from any experienced cql user will last more than a moment.