Please, check this.
https://supabase.com/blog/postgres-pluggable-strorage
https://www.pgcon.org/events/pgcon_2023/schedule/session/470...
Pushing patches to PostgreSQL Core requires a lot of work. But there is a progress already: 5k lines patchset to PG 14, and 2k lines patchset to PG 16.