duckdb: a table name or alias used as a value (SELECT p FROM plan p, plan_doc(p)) is an unknown column #4677

Version

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?

DuckDB lets a query refer to a table or its alias as a value. The reference is a STRUCT of the row's columns, which is the usual way to hand a whole row to a macro:

CREATE MACRO plan_doc(r) AS json_object('id', r.id, 'boxSize', r.box_size, 'price', r.price);
SELECT p.id, plan_doc(p) AS doc FROM plan p;

The sqlc DuckDB engine rejects every form of that reference with unknown column:

The last row shows the macro itself is fine. It is the bare row reference that does not resolve.

A view in the schema that uses the form fails the same way: with CREATE VIEW plan_document AS SELECT id, plan_doc(p) AS doc FROM plan p in schema.sql, every sqlc generate ends in schema.sql:1:1: view "plan_document": unknown column "p".

Expected: a one-part name that matches a relation in scope and no column resolves to a struct of that relation's columns, like DuckDB itself.

Relevant log output

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

Database schema

CREATE TABLE plan (
    id UUID NOT NULL,
    box_size VARCHAR NOT NULL,
    price DOUBLE
);
CREATE MACRO plan_doc(r) AS json_object('id', r.id, 'boxSize', r.box_size, 'price', r.price);

SQL queries

-- name: RowStruct :many
SELECT p FROM plan p;

-- name: RowText :many
SELECT p.id, CAST(p AS VARCHAR) AS row_text FROM plan p;

-- name: RowMacro :many
SELECT p.id, CAST(plan_doc(p) AS VARCHAR) AS doc FROM plan p;

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