While I appreciate postgres flexibility this feels like a mistake. A bit like a person insisting Rust is best and using other languages are unnecessary.

You could, but it is going to force technical compromises. Even tools that can do everything aren't the best at everything.