[duckdb extension] Parser rejects table-valued function column alias syntax (range(10) t(x))

[Anant-mishra1729]

Environment

• ggsql DuckDB extension version: v0.4.1
• DuckDB version: v1.5.4
• Installed via: INSTALL ggsql FROM community; LOAD ggsql;
• OS: MacOS

Description

The README in posit-dev/ggsql-duckdb documents the following as a working example:

SELECT * FROM range(10) t(x) VISUALISE x, x*x AS y DRAW line;

And via the scalar function:

SELECT ggsql('SELECT * FROM range(10) t(x) VISUALISE x, x*x AS y DRAW line');

Both produce a parse error on v0.4.1:

memory D SELECT ggsql('SELECT * FROM range(10) t(x) VISUALISE x, x*x AS y DRAW line');
Invalid Input Error:
ggsql: Parse error: Parse tree contains errors

[Anant-mishra1729]

Closing it here - raised it on posit-dev/ggsql-duckdb#11

[teunbrand]

I think the problem is x * x AS y, where the grammar would expect <column_name> AS y and not the expression x * x. There some discussion to be had about whether we ought to allow this, and whether we can improve the messaging, but the behaviour itself is expected for now.