[BUG] Missing function: sha2

[rampage644]

Function: sha2
Category: Hash
Status: Failed (Return Code: 1)
Documentation: https://docs.snowflake.com/en/sql-reference/functions/sha2

Test SQL:

SELECT SHA2('snowflake', 256);

Expected Result:

N/A

Actual Result:

SELECT SHA2('snowflake', 256);

Stderr:

╭─ Error ──────────────────────────────────────────────────────────────────────────────────────────────────────╮
│ 000200: 200: DataFusion error: Error during planning: Invalid function 'sha2'.                               │
│ Did you mean 'sha224'?                                                                                       │
╰──────────────────────────────────────────────────────────────────────────────────────────────────────────────╯

Parent EPIC: #570

[rampage644]

Need this earlier due to high impact on gitlab dbt pipelines: 22 encounters for DataFusion error: Error during planning: Invalid function 'sha2'.