feat(snowflake)!: Type annotation for Snowflake ENCRYPT and DECRYPT functions

[fivetran-kwoodbeck]

Added type annotation and tests for Snowflake's encryption functions, with TRY_ variants for decryption.

Documentation:
https://docs.snowflake.com/en/sql-reference/functions/encrypt
https://docs.snowflake.com/en/sql-reference/functions/encrypt_raw
https://docs.snowflake.com/en/sql-reference/functions/decrypt
https://docs.snowflake.com/en/sql-reference/functions/decrypt_raw
https://docs.snowflake.com/en/sql-reference/functions/try_decrypt
https://docs.snowflake.com/en/sql-reference/functions/try_decrypt_raw

[github-actions]

SQLGlot Integration Test Results

Comparing:

• this branch (sqlglot:feature/annotatetype-encryption, sqlglot version: feature/annotatetype-encryption)
• baseline (main, sqlglot version: 28.5.1.dev49)

⚠️ Limited to dialects: snowflake

By Dialect

dialect	main	sqlglot:feature/annotatetype-encryption	difference	links
snowflake -> duckdb	626/1085 passed (57.7%)	626/1085 passed (57.7%)	No change	full result / delta
snowflake -> snowflake	981/1085 passed (90.4%)	981/1085 passed (90.4%)	No change	full result / delta

Overall

main: 2170 total, 1607 passed (pass rate: 74.1%), sqlglot version: 28.5.1.dev49

sqlglot:feature/annotatetype-encryption: 2170 total, 1607 passed (pass rate: 74.1%), sqlglot version: feature/annotatetype-encryption

Difference: No change

[geooo109]

Nice work!

Left some comments.

Moreover, these functions exist only in snowflake ?

[fivetran-kwoodbeck]

@VaggelisD For the other dialects, I checked both ENCRYPT and DECRYPT and did not find anything. The ones that support encryption seem to use the name AES_ENCRYPT or similar.

[geooo109]

Nice, thank you!