I've put in a couple of merges on Beem (which is the most comprehensive library for Hive on Python) recently and taken a look at it.
It does need significant work to pull it up to modern standards with typing and the whole way it handles dates needs to be made timezone aware.
I think perhaps the proposal is too wide in terms of what you hope you can do, but we need significant extra work in these areas I agree.
I'm voting for this.