Incorrect parsing and generating of SHA, SHA2, MD5, and MD5_Digest expressions in Presto/Trino dialect

[viplazylmht]

SQLglot version: 23.15.1
The issue still exists on main

Fully reproducible code snippet

SHA:
Actually:

>>> from sqlglot import parse_one
>>> parse_one("SHA(col_x)", read="").sql(dialect="presto")
'SHA(col_x)'
>>>

Expected output:

>>> from sqlglot import parse_one
>>> parse_one("SHA(col_x)", read="").sql(dialect="presto")
'SHA1(col_x)'
>>>

SHA2:
Actually:

>>> from sqlglot import parse_one
>>> parse_one("SHA2(col_x, 256)", read="").sql(dialect="presto")
'SHA2(col_x, 256)'
>>> parse_one("SHA512(col_x)", read="bigquery").sql(dialect="presto")
'SHA512(col_x, 512)'
>>>

Expected output:

>>> from sqlglot import parse_one
>>> parse_one("SHA2(col_x, 256)", read="").sql(dialect="presto")
'SHA256(col_x)'
>>> parse_one("SHA512(col_x)", read="bigquery").sql(dialect="presto")
'SHA512(col_x)'
>>>

MD5:
Actually:

>>> from sqlglot import parse_one
>>> parse_one("MD5(col_x)", read="").sql(dialect="presto")
'MD5(col_x)'
>>>

Expected output:

>>> from sqlglot import parse_one
>>> parse_one("MD5(col_x)", read="").sql(dialect="presto")
'LOWER(TO_HEX(MD5(col_x)))'
>>>

MD5_Digest:
Actually:

>>> from sqlglot import parse_one
>>> parse_one("MD5_Digest(col_x)", read="").sql(dialect="presto")
'MD5_DIGEST(col_x)'
>>>

Expected output:

>>> from sqlglot import parse_one
>>> parse_one("MD5_Digest(col_x)", read="").sql(dialect="presto")
'MD5(col_x)'
>>>

Official Documentation

• https://prestodb.io/docs/current/functions/binary.html#md5
• https://trino.io/docs/current/functions/binary.html#md5