I tried to identify the engine (Cassandra, Scylla, AstraDB, CosmosDB, Yugabyte, …) based on Cassandra Query Language (CQL). I focused on tables system.local and system.peers, see the sample: