TRUNCATE operation fails against Azure CosmosDB Cassandra API and AWS Keyspaces for Apache Cassandra

[DanZDatical]

Both services claim 'wire compatibility' with Cassandra, but their emulations do not support a number of commands, objects, etc.

For this extension, the immediate problem is clearing DATABASECHANGELOGLOCK, which relies on a TRUNCATE operation. This is not supported by either emulator. Therefore, while connecting is possible, no operations work.

The likely related code is: I believe the relevant code is here https://github.com/liquibase/liquibase-cassandra/blob/main/src/main/java/liquibase/ext/cassandra/sqlgenerator/DeleteGeneratorCassandra.java

What is less clear is that if the workarounds required to accommodate this - and the other limitations of those emulators as of this writing - would impact native Cassandra compatibility enough to necessitate a fork of this extension codebase rather than modification.

• AWS documentation: https://docs.aws.amazon.com/keyspaces/latest/devguide/cassandra-apis.html
• Azure documentation: https://docs.microsoft.com/en-us/azure/cosmos-db/cassandra/cassandra-support#:~:text=The%20Azure%20Cosmos%20DB%20Cassandra%20API%20is%20compatible%20with%20Cassandra,and%20exceptions%20are%20listed%20below.