It's possible to improve cql to a cql++ .. if you start going this path, it will lead to sql which isn't bad a all ;)
It's not 'fair' to compare CQL to SQL, if you compare CQL to DynamoDB's http api, which scylla implements as well, you'll see that cql is better: https://www.scylladb.com/2020/05/12/comparing-cql-and-the-dy...