Parser rejects table-valued function column alias syntax (range(10) t(x))

Hi, I was using this tool with DuckDB, but I ran into this issue. I tried various workarounds, and here's what I found. Thanks!

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

Steps to reproduce

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

Probable issue

ggsql parser does not handle DuckDB's table-valued function column alias syntax range(10) t(x)

Workaround

Using a CTE with unnest(range(10)) works correctly:

WITH nums AS (SELECT unnest(range(10)) AS x)
SELECT x, x*x AS y FROM nums
VISUALISE x, y
DRAW line;

The README example in posit-dev/ggsql-duckdb is broken and should be
updated to use the CTE workaround until this is fixed.

Start by running the SQL reproduction from the issue against the documented README example, then compare it with the working CTE workaround. Trace how ggsql parses the table-valued function alias syntax range(10) t(x). Done means the documented query parses successfully, or the README is updated to use the CTE workaround until parser support is available.