def METHOD_NAME():
    output = """
        select cast(l.source_dataset as varchar) || '-__-' ||
        cast(l.unique_id as varchar) as concat_id
    """
    output = sqlglot.parse_one(output).sql()
    sql = "select l.source_dataset || '-__-' || l.unique_id as concat_id"
    transformed_sql = sql = sqlglot_transform_sql(sql, cast_concat_as_varchar)
    assert transformed_sql == output
    sql = """
        select cast(l.source_dataset as varchar) || '-__-' ||
        l.unique_id as concat_id
    """
    transformed_sql = sql = sqlglot_transform_sql(sql, cast_concat_as_varchar)
    assert transformed_sql == output
    sql = """
        select cast(l.source_dataset as varchar) || '-__-' ||
        cast(l.unique_id as varchar) as concat_id
    """
    transformed_sql = sql = sqlglot_transform_sql(sql, cast_concat_as_varchar)
    assert transformed_sql == output
    sql = "select source_dataset || '-__-' || unique_id as concat_id"
    transformed_sql = sql = sqlglot_transform_sql(sql, cast_concat_as_varchar)
    assert transformed_sql == output.replace("l.", "")