SQLite upsert does not work

[Elara6331]

Version

Other

What happened?

SQLite upsert syntax is not working using the beta SQLite engine from the latest main branch.

Relevant log output

mismatched input '=' expecting '=='

Database schema

CREATE TABLE IF NOT EXISTS locations (
    id              INTEGER PRIMARY KEY,
    name            TEXT    NOT NULL,
    address         TEXT    NOT NULL,
    zip_code        INT     NOT NULL,
    latitude        REAL    NOT NULL,
    longitude       REAL    NOT NULL,
    UNIQUE(name)
);

SQL queries

INSERT INTO locations (
    name,
    address,
    zip_code,
    latitude,
    longitude
)
VALUES (?, ?, ?, ?, ?)
ON CONFLICT(name) DO UPDATE SET 
    name = excluded.name,
    address = excluded.address
    zip_code = excluded.zip_code
    latitude = excluded.latitude
    longitude = excluded.longitude;

Configuration

No response

Playground URL

No response

What operating system are you using?

Linux

What database engines are you using?

No response

What type of code are you generating?

Go

[talksik]

Still not working for me:

-- name: UpsertUser :exec
INSERT INTO users (user_id, status)
VALUES (@userId, @newStatus)
ON CONFLICT (user_id) 
DO UPDATE SET status = @updatedStatus;

Generated:

const upsertUser = `-- name: UpsertUser :exec
INSERT INTO users (user_id, status)
VALUES (?1, ?2)
ON CONFLICT (user_id) 
DO UPDATE SET status = @updatedStatus
`

type UpsertUserParams struct {
	UserId    string
	NewStatus int64
}

func (q *Queries) UpsertUser(ctx context.Context, arg UpsertUserParams) error {
	_, err := q.db.ExecContext(ctx, upsertUser, arg.UserId, arg.NewStatus)
	return err
}

The last arg is not being parsed.

Tried updating sqlc as well: v1.26.0

[orisano]

repro: https://play.sqlc.dev/p/815dd8823fdf9bbe30ca9f4c9a96f2511c165c90896af98a68c05f3584e69ec9

[talksik]

Oh thank you @orisano ! Appreciate ya :)

[sztanpet]

Still happening