Snowflake Data Type Coverage

[paulojblack]

Following #77 I did not test Snowflake data types exhaustively. Appropriate Scotty's test query and ensure sufficient data type support is present

SELECT
    TRUE AS bool_col,
    42 AS int_col,
    9223372036854775807::BIGINT AS bigint_col,
    32767::SMALLINT AS smallint_col,
    127::TINYINT AS tinyint_col,
    127::BYTEINT AS byteint_col,
    3.14159::FLOAT AS float_col,
    3.141592653589793::DOUBLE AS double_col,
    3.1415926535::DECIMAL(38,10) AS decimal_col,
    3.1415926535::NUMERIC(38,10) AS numeric_col,
    3.1415926535::NUMBER(38,10) AS number_col,
    'Hello, World!'::VARCHAR(100) AS varchar_col,
    'ABCDEFGHIJ'::CHAR(10) AS char_col,
    'This is a string'::STRING AS string_col,
    'This is a text column'::TEXT AS text_col,
    HEX_ENCODE('binary')::BINARY AS binary_col,
    HEX_ENCODE('varbinary')::VARBINARY AS varbinary_col,
    CURRENT_DATE() AS date_col,
    CURRENT_DATETIME() AS datetime_col,
    CURRENT_TIME() AS time_col,
    CURRENT_TIMESTAMP() AS timestamp_col,
    CURRENT_TIMESTAMP()::TIMESTAMP_LTZ AS timestamp_ltz_col,
    CURRENT_TIMESTAMP()::TIMESTAMP_NTZ AS timestamp_ntz_col,
    CURRENT_TIMESTAMP()::TIMESTAMP_TZ AS timestamp_tz_col,
    PARSE_JSON('{"key": "value"}') AS variant_col,
    OBJECT_CONSTRUCT('key', 'value') AS object_col,
    ARRAY_CONSTRUCT(1, 2, 3) AS array_col
    ```