FWIW, we use https://cgsql.dev/ to solve the type issue, among others. I totally understand that this is not for everyone.