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.
You can now pass a host parameter to session.execute/executeAsync. The LBP will be ignored and the query will be sent to that specific host.