feat: Support integer types other than `BIGINT`

[edgarrmondragon]

Description

Use JSON schema hints to determine the appropriate integer column type.

It's not currently supported. It can be done by updating this line:

target-postgres/target_postgres/connector.py

Line 263 in edbfad7

to_sql.register_type_handler("integer", BIGINT)

to use a function that checks for certain JSON schema metadata to decide what type of int column to return. I'll log an issue in the GH repo later, unless you beat me to it.

Links:

• Slack: https://meltano.slack.com/archives/C069A0GE129/p1732698467532499
• https://www.postgresql.org/docs/13/datatype-numeric.html