Unsupported expression type ArrayContained

[Toms1999]

Before you file an issue

• Make sure you specify the "read" dialect eg. parse_one(sql, read="postgres")
• Make sure you specify the "write" dialect eg. ast.sql(dialect="mysql")
• Check if the issue still exists on main:Couldn't find anything related

Fully reproducible code snippet

import sqlglot

sql = """select string_to_array('dd,ee', ',') <@array['dd','ee','ff','gg','hh'];"""

result1 = sqlglot.transpile(sql, read='postgres', write='mysql')[0]

print(result1)

The generator function throws an error:
ValueError: Unsupported expression type ArrayContained

Official Documentation
Please include links to official SQL documentation related to your issue.

(postgres array/string_to_array)