PostgreSQL parser fails on column alias list after LATERAL unnest

Describe the bug

The PostgreSQL parser fails to parse a LATERAL unnest(...) table function when its alias includes a column alias list, such as:

AS "pid"("id")

This is valid PostgreSQL syntax. The parser accepts AS "pid" but reports a syntax error on the ( in AS "pid"("id").

Database Engine

PostgreSQL

To Reproduce

SQL being parsed:

SELECT "pid"."id"
FROM (
  SELECT ARRAY[1, 2]::integer[] AS "Parent ids"
) AS "e"
LEFT JOIN LATERAL unnest(
  COALESCE("e"."Parent ids", ARRAY[]::integer[])
) AS "pid"("id") ON TRUE;

JavaScript:

const { Parser } = require('node-sql-parser');

const parser = new Parser();

const sql = `
SELECT "pid"."id"
FROM (
  SELECT ARRAY[1, 2]::integer[] AS "Parent ids"
) AS "e"
LEFT JOIN LATERAL unnest(
  COALESCE("e"."Parent ids", ARRAY[]::integer[])
) AS "pid"("id") ON TRUE;
`;

const ast = parser.astify(sql, {
  database: 'postgresql',
});

Error:

SyntaxError: Expected ")", ",", "ON", "JOIN", "WHERE", ...
but "(" found.

The unexpected ( is the opening parenthesis in:

AS "pid"("id")
        ^

Versions:

node-sql-parser: 5.4.0
Node.js: v22.21.1

Expected behavior

The query should parse successfully.

PostgreSQL supports assigning a table alias and an output-column alias to a table function:

unnest(...) AS "pid"("id")

The unnested value can then be referenced as:

"pid"."id"

Screenshots

Not applicable. The parser error and reproduction are included above.

Additional context

Removing the column alias list allows the query to parse:

LEFT JOIN LATERAL unnest(
  COALESCE("e"."Parent ids", ARRAY[]::integer[])
) AS "pid" ON TRUE

However, the output column must then be referenced using its default name:

"pid"."unnest"

Therefore, this appears to be a limitation in parsing PostgreSQL table-function column aliases rather than invalid PostgreSQL syntax.