Decouple JSON conversion and type conversion.

[copybara-service[bot]]

Decouple JSON conversion and type conversion.

• Removes the concept of json value converters, as it is no longer needed because the introduction of opaque object serialization.
• Accepts tuple as the value for the dest argument for pg.typing.get_converter, and remove pg.typing.get_first_applicable_converter.