SNOW-1871582: Array support broken in 1.7.2

[jochenott]

1. What version of Python are you using? 3.12

2. What operating system and processor architecture are you using? osx-arm64

3. What are the component versions in the environment (pip freeze)?
   snowflake-sqlalchemy 1.7.2 and sqlalchemy 1.X

4. What did you do? Compile a "create table" statement for a table that contains a column with "array" type.

5. What did you expect to see? No exception. Instead, there was an exception.

To reproduce:

from snowflake.sqlalchemy.snowdialect import SnowflakeDialect
import sqlalchemy as sa

dialect = SnowflakeDialect()

table = sa.Table(
    "table",
    sa.MetaData(),
    sa.Column(
        "array_str_column",
        sa.ARRAY(sa.String),
    ),
)
create_table = sa.sql.ddl.CreateTable(table)
print(str(create_table.compile(dialect=dialect)))

This worked for snowflake-sqlalchemy 1.7.1 without raising an exception.

For snowflake-sqlalchemy 1.7.2, this results in an exception AttributeError: 'ARRAY' object has no attribute 'is_semi_structured' pointing to this line as the culprit of the attribute error:

snowflake-sqlalchemy/src/snowflake/sqlalchemy/base.py

Line 1099 in 115da35

if type_.is_semi_structured:

This code was introduced in #560 .

[sfc-gh-dszmolka]

hi - thank you for raising this issue with us. We regret seeing how much issues you have with this library and will work on rectifying it. The issue is now with the dev team who will take a look.