SNOW-1345376: SnowflakeDDLCompiler overrides get_identity_options but doesn't use it anywhere

[DanielTatarkin]

Please answer these questions before submitting your issue. Thanks!

1. What version of Python are you using?

   Python 3.9.X

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

   macOS-14.4.1-arm64-arm-64bit

3. What are the component versions in the environment (pip freeze)?

   unrelated

4. What did you do?

Creating SQLAlchemy ORM models with AUTOINCREMENT | IDENTITY sequence does not read identity options in order to apply them to SEQUENCE objects or Columns with AUTOINCREMENT | IDENTITY.

5. What did you expect to see?

   Identity options should be set on SEQUENCE objects and/or Columns with AUTOINCREMENT | IDENTITY.

   See examples:

• Base DDLCompiler usage in visit_create_sequence
• Google SpannerDDLCompiler usage in visit_create_sequence
• Oracle OracleDDLCompiler usage in visit_identity_column

6. Can you set logging to DEBUG and collect the logs?

   N/A

[sfc-gh-dszmolka]

hi - thank you for raising this and also for the suggested solution, appreciated! we'll review.

[sfc-gh-dszmolka]

i see the associated PR has been merged earlier this year and since then there was at least 1 release