That's true.

There seems to be two planes of ease of use - the app layer (library) and the infra layer (hosting).

The app layer for Postgres is still in development, so if you currently want to run pub-sub (Kafka) on it, it will be extra work to develop that abstraction.

I hope somebody creates such a library. It's a one-time cost but then will make it easier for everybody.