engine: sqlite json_each parameter not getting replaced with positional parameter

[lumosminima]

Version

1.27.0

What happened?

I've also reported this on sqlc-dev/sqlc-gen-typescript#53.

Relevant log output

const getAuthor = `-- name: GetAuthor :one
SELECT id, name, bio FROM authors
WHERE id = ?1 AND (
      ?2 IS NULL
      OR name IN (
        SELECT value
        FROM json_each(@names)
      )
    ) LIMIT 1
`

Database schema

No response

SQL queries

-- name: GetAuthor :one
SELECT * FROM authors
WHERE id = @id AND (
      @name IS NULL
      OR name IN (
        SELECT value
        FROM json_each(@names)
      )
    ) LIMIT 1;

Configuration

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

Playground URL

https://play.sqlc.dev/p/8c9eef14c721c93dbf457729132606f6a7011193f13ad3f20b0ed006ccd40050

What operating system are you using?

Linux

What database engines are you using?

SQLite

What type of code are you generating?

Go