Check out slonik if you want something that does not go full pg-types. I combine it with io-ts for runtime validation.