RFC: CQLSh safe mode. Example: are you sure prompt before dropping a table/keyspace

[tzach]

This is from a disclose user

I accidentally dropped the wrong keyspace... We don't have backups running . Is there any way that I can stop the keyspace from dropping and losing all the data?

It would be nice if cqlsh can validate before doing an irreversible dangerous action, like dropping a keyspace.

For example:

Are you sure you want to DROP KEYSPACE xxx? [N/y]

This can be part of a "safe-mode" or Garudrail CQLSh mode (not sure it is needed)
https://issues.apache.org/jira/browse/CASSANDRA-12349

One can claim this should be a core feature, but since IMHO, it does not make sense to add such limits on API calls.