snowflake -> duckdb ordered listagg transpilation error

[btyuhas]

DuckDB doesn't use the WITHIN GROUP syntax to order a listagg output. Its instead added into the function call like listagg(col, sep ORDER BY col2)

Fully reproducible code snippet

snowsql = """
    select
        col0,
        listagg(col1, ', ') within group (order by col2)
    from (values
        (1, 'a', 3),
        (2, 'b', 2),
        (3, 'c', 1)
    )
    group by col0
"""
ducksql = sqlglot.transpile(snowsql, read='snowflake', write='duckdb')[0]
print(ducksql)

yields

SELECT col0, GROUP_CONCAT(col1, ', ') WITHIN GROUP (ORDER BY col2) FROM (VALUES (1, 'a', 3), (2, 'b', 2), (3, 'c', 1)) GROUP BY col0

which throws ParserException: Parser Error: Unknown ordered aggregate "GROUP_CONCAT".

I would expect the transpiler to output this:

select
    col0,
    group_concat(col1, ', ' order by col2)
from (values
    (1, 'a', 3),
    (1, 'b', 2),
    (1, 'c', 1)
)
group by col0

Official Documentation

https://duckdb.org/docs/sql/aggregates
https://docs.snowflake.com/en/sql-reference/functions/listagg