Query "SELECT * FROM unnest(..)" has wrong generated code

[AntonOcean]

Version

1.25.0

What happened?

This is my expectation from SQL-query



But this is a reality of SQLC generated code

Relevant log output

const getAuthors = `-- name: GetAuthors :exec
SELECT unnest FROM unnest($1::authors[])
`

Database schema

CREATE TABLE authors (
  id   BIGSERIAL PRIMARY KEY,
  name text      NOT NULL,
  bio  text
);

SQL queries

-- name: GetAuthors :exec
SELECT * FROM unnest($1::authors[]);

Configuration

{
  "version": "2",
  "sql": [{
    "schema": "schema.sql",
    "queries": "query.sql",
    "engine": "postgresql",
    "gen": {
      "go": {
        "out": "db"
      }
    }
  }]
}

Playground URL

https://play.sqlc.dev/p/92a526ef05f1b3ec8c4dbc2360e1ff0c7cc27464a8b5870957166137b8e119af

What operating system are you using?

macOS

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go