This was driven by Andres Freund for pg12. Please, check this.
https://anarazel.de/talks/2018-10-25-pgconfeu-pluggable-stor...
However, the current table AM API in many aspects assumes heap-like storage. This is why OrioleDB comes with a patchset we're intended to upstream to PostgreSQL.