Version

1.29.0

What happened?

If I use $AAA parameters with SQLite I will get an error but this is supported by the engine as said on SQLite SQL Language Expressions > Parameters.

In sqlite3_bind() its said:

"In the SQL statement text input to sqlite3_prepare_v2() and its variants, literals may be replaced by a parameter that matches one of the following templates:

?
?NNN
:VVV
@VVV
$VVV
In the templates above, NNN represents an integer literal, and VVV represents an alphanumeric identifier. The values of these parameters (also called "host parameter names" or "SQL parameters") can be set using the sqlite3_bind_*() routines defined here."

Relevant log output

line 17:15 no viable alternative at input 'UPDATE handles\n    SET name = $'
# package 
sql/queries/handles.sql:1:1: no viable alternative at input 'UPDATE handles\n    SET name = $'

Database schema

-- +goose Up
-- +goose StatementBegin
CREATE TABLE handles(
    id TEXT PRIMARY KEY CHECK (length(id) == 36), -- UUID
    name TEXT NOT NULL UNIQUE CHECK (length(name) <= 32), -- @foo, no symbols/spaces
    created_at INTEGER NOT NULL DEFAULT (strftime('%s', 'now')), -- Unix timestamp
    updated_at INTEGER NOT NULL -- Unix timestamp
);
-- +goose StatementEnd

-- +goose Down
-- +goose StatementBegin
DROP TABLE handles;
-- +goose StatementEnd

SQL queries

-- name: UpdateHandle :one
UPDATE handles
    SET name = $2,
    updated_at = NOW()
    WHERE id = $1
RETURNING id, created_at, updated_at, name;

Configuration

version: "2"
sql:
  - engine: "sqlite"
    schema: "sql/schema/migrations"
    queries: "sql/queries"
    gen:
      go:
        out: "internal/database"

Playground URL

https://play.sqlc.dev/p/7ff6c3d5268c762b76276042ccfe9bf9bf067d52c5eae4644f6dcf329fb65b74

What operating system are you using?

Linux

What database engines are you using?

SQLite

What type of code are you generating?

Go