I have a ClickHouse table with a tags column of type Map(String, String).

When exporting this data, I’d like to explode the tags map into columns. For example if I had in row 1 tags: {"key1":"value1"} and in row 2 tags: {"key5": "value75"} there should be two columns in the exported table called key1 and key5. Missing values should just be null. The tags map can contain arbitrary values.

How can I achieve this in ClickHouse?