I've been playing around with EdgeDB lately and it addresses a lot of the concerns you laid out. Might be worth a look.