Through CASSANDRA-7622, virtual tables will be introduced in Apache Cassandra 4.0.
There is currently no trivial mechanism to send a query to a specific node. Sending queries to a specific node is not a very typical use case, but with virtual tables this changes. For example, in order to ascertain metrics for a particular node, you need to query the associated system view on that node.