A Guide to Native PostgreSQL Foreign Data Wrappers

I spent the last few weeks creating a PostgreSQL Foreign Data Wrapper (FDW). I wanted to record a bunch of things I learned along the way. Many of the reasons why the FDWs are structure in the way they are lightly documented, so this should help those looking to build these in the future.