Query and storage layer are nicely separated in the Postgres codebase, you can absolutely rip out the complete backend if you really want it.

There is a Postgres interface to Spanner which probably did that.