R doesn't stand for row-store. The access patterns of Clickhouse are comparable with any RDBMS. The fact that it happens to be a column-store doesn't make it not an RDBMS. It doesn't mean "row-oriented databases designed for OLTP workloads" as it appears you think is the case.
Should I have simply said "SQL databases where data is represented in tables with a defined schema" to simplify the discussion and prevent your ignorant diatribe?