Comment by PeterZaitsev

In this case PostgreSQL may be able to come to the rescue :)

There is Clickhouse FDW for PostgreSQL which in some cases can provide great speed with full join support

https://github.com/adjust/clickhouse_fdw