feat(snowflake)!: annotate types for MAP_* functions

[fivetran-kwoodbeck]

Documentation:

https://docs.snowflake.com/en/sql-reference/functions/map_cat
https://docs.snowflake.com/en/sql-reference/functions/map_contains_key
https://docs.snowflake.com/en/sql-reference/functions/map_delete
https://docs.snowflake.com/en/sql-reference/functions/map_insert
https://docs.snowflake.com/en/sql-reference/functions/map_keys
https://docs.snowflake.com/en/sql-reference/functions/map_pick
https://docs.snowflake.com/en/sql-reference/functions/map_size

[github-actions]

SQLGlot Integration Test Results

Comparing:

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

⚠️ Limited to dialects: snowflake

By Dialect

dialect	main	sqlglot:feature/annotatetype-map_functions	difference	links
snowflake -> duckdb	622/1085 passed (57.3%)	624/1085 passed (57.5%)	⬆ improved by 0.2%	full result / delta
snowflake -> snowflake	975/1085 passed (89.9%)	975/1085 passed (89.9%)	No change	full result / delta

Overall

main: 2170 total, 1597 passed (pass rate: 73.6%), sqlglot version: 28.5.1.dev15

sqlglot:feature/annotatetype-map_functions: 2170 total, 1599 passed (pass rate: 73.7%), sqlglot version: feature/annotatetype-map_functions

Difference: ⬆ improved by 0.1%

[geooo109]

Did you also check if other databases support these functions ?

[fivetran-kwoodbeck]

Did you also check if other databases support these functions ?

@georgesittas yes, here is what matched the searches:

MAP_CAT: snowflake only
MAP_CONTAINS_KEY:
spark	https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.functions.map_keys.html
MAP_DELETE: snowflake only
MAP_INSERT: snowflake only
MAP_PICK:	snowflake only
MAP_KEYS:
hive	https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF
presto	https://prestodb.io/docs/current/functions/map.html
spark	https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.functions.map_keys.html
trino	https://trino.io/docs/current/functions/map.html
databricks	https://docs.databricks.com/aws/en/sql/language-manual/functions/map_keys
MAP_SIZE:	snowflake only