+1. I checked Citus, hydra, etc, and nothing comes close, all has its restrictions or gotchas.
I also really want to have a LSM based storage engine, but noone implemented it yet. Yugabyte built a postgres compatible database, but it has some management-related stuff not opensource... Cockroach similarly...