duckdb: the rowid pseudo-column is an unknown column #4676

Version

Other

main at commit 3ad8b20, built with CGO_ENABLED=0 go install github.com/sqlc-dev/sqlc/cmd/sqlc@3ad8b20fb02b5bea81591b673da0758b8685d951. sqlc version prints v1.31.1.

What happened?

Every DuckDB base table has a rowid pseudo-column (BIGINT) that can be selected, filtered on and ordered by. DuckDB sqlc engine does not know it:

all of these work on duckdb 2.0, DESCRIBE SELECT rowid FROM plan reports a nullable BIGINT.

Relevant log output

# package q
queries/query.sql:1:1: unknown column "rowid"

Database schema

CREATE TABLE plan (
    id UUID NOT NULL,
    ship_size VARCHAR NOT NULL,
    price DOUBLE
);

SQL queries

-- name: WithRowID :many
SELECT rowid, id FROM plan;

-- name: ByRowID :one
SELECT id FROM plan WHERE rowid = $1;

Configuration

version: "2"
sql:
  - engine: "duckdb"
    schema: "schema.sql"
    queries: "queries"
    gen:
      go:
        package: "q"
        out: "q"
        sql_package: "database/sql"

Playground URL

No response

What operating system are you using?

Linux

What database engines are you using?

DuckDB

What type of code are you generating?

Go