Clickhouse looks more complicated because instead of

    create table bla (
      id number,
      xyz varchar
    )

you're doing things like

    create table bla (
      id uint64 CODEC(DoubleDelta(8)),
      xyz Nullable(LowCardinality(Varchar)) CODEC(ZSTD(1))
    )
    engine=MergeTree
    order by id

but I do wonder what is the performance difference between actually carefully specifying everything and leaving defaults (except for order by I guess).