"BETWEEN ? AND ?" not working in SQLite

[TeddyDD]

What do you want to change?

Same request as #1077, but for SQLite

Dumb example:

-- name: ListAuthorBet :many
SELECT * FROM authors
WHERE id BETWEEN ? AND ?;

Results in

func (q *Queries) ListAuthorBet(ctx context.Context) ([]Author, error) {
...

Tested on current main (3623ec8)

What database engines need to be changed?

No response

What programming language backends need to be changed?

No response

[mvdan]

Is this fixed by #1967?

[TeddyDD]

Yes, thanks for heads up!