Select element from collection map/set like map[key]

I want to select specific keys from a map/set in scylla, it seems this has been an open issue since a long time. Is this functionality available in the latest version, if not when can we expect this?

Query : select map[‘key’] from table where id = ?

Git issue : Allow selecting map values and set elements, like in Cassandra 4.0 #7751

Hi @rohit_ranjan

Take a look at this PR# https://github.com/scylladb/scylladb/pull/22051

If you grab our latest 2025.1.2 release, you should have the functionally as described in the PR.

Best regards,
Gabriel