I want something that I can share with a development team that's just focused on features and doesn't want to think about the tools at hand very much (but can deeply fine-tune where needed).
Postgraphile seems like an amazing place to start for this.
Here's what I might want to build on top of it (though ideally it'd be baked-in):
Each "table" (think pg_class) should have a single file where ~all logic around that table is contained in as declarative a format as possible.