SNOW-922868: Preserve the sequence order of foreign keys when dealing with composite keys.

[skp33]

Hi Team,

I am encountering issues while working with composite foreign keys. For every version, I am receiving fixed create_foreign_key and drop_constraint operations. Upon debugging, I discovered that we are not preserving the sequence order of foreign keys when comparing with metadata.

For more detail, I am pointing out the specific code snippet that requires modification. - https://github.com/snowflakedb/snowflake-sqlalchemy/blob/main/src/snowflake/sqlalchemy/snowdialect.py#L414-L434C18

[sfc-gh-dszmolka]

hi - apologies for not being able to pick this up earlier. we'll take a look. also appreciate the PR proposal!