Support for slices input parameters

[prog8]

Is your feature request related to a problem? Please describe.
Today when I try to use named parameters and inject a slice of integer there I get an error

unsupported type []int, a slice of int

Describe the solution you'd like

Support for slices to cover IN clause

[thibleroy]

Hello prog8, did you find an alternative?

[prog8]

Unfortunately not. I had to do ugly SQL string building :(

[thibleroy]

I found a way using sqlx:

p := []int64{1, 2}

query, args, err := sqlx.In("SELECT Id FROM TableName where Id IN (?)", p)

...

query = db.Rebind(query) // db is your sqlx.DB instance

var ids []
err = db.SelectContext(ctx, &ids, query, args...)

This might help: https://jmoiron.github.io/sqlx/#inQueries