Supporting Datetimeoffset. Bug Fix: Tinyint and Datetime2

[s7clarke10]

tap-mssql 2.2.0 2023-08-23

This feature increases support for SQL Datatypes.

• Adds support for datetimeoffset - https://github.com/wintersrd/pipelinewise-tap-mssql/issues/50
• Resolves issue with datetime2 rounding with high precision timestamps https://github.com/wintersrd/pipelinewise-tap-mssql/issues/51
• Resolves the max and min range for tinyints. The current min and max are correct for MariaDB and MySQL only. MSSQL Server only supports positive integers (unsigned tinyint). https://github.com/wintersrd/pipelinewise-tap-mssql/issues/2

Please Note: For datetimeoffset the output follows the Singer Framework recommendation - that is the offset is emitted in UTC format.

[seemiyah]

Have successfully tested these changes between mssql and snowflake. column types: smallint, int, bigint, tinyint, datetimeoffset test values: low values, high values, and nulls test type: full_table and log_based load

Datetime value of 9999-12-31 23:59:59.999 also tested.

Screenshots of inputs and outputs attached.

Note that value of MSSQL value of 2023-08-22 08:24:32.1277000 +10:00 is correctly displayed as 2023-08-21 22:24:32.127 in Snowflake (NZ local time)