Where with raw sql string and slice arg

[m15h4nya]

Given:

query := sq.Select("something FROM somewhere").Where("id NOT IN ?", []int{1, 2, 3})

Expected:

SELECT something FROM somewhere WHERE id NOT IN (1, 2, 3);

Actual:

SELECT something FROM somewhere WHERE id NOT IN '[1 2 3]';

Trying to actually execute query returns error (SQLSTATE 42601) saying there is syntax error near ? (or $1 if using dollar placeholders)

go play: https://go.dev/play/p/79B21fBnUgJ

[torbenj]

Using sq.NotEq might solve this issue:

query := sq.Select("something FROM somewhere").Where(sq.NotEq{"id": []int{1, 2, 3}})

[m15h4nya]

@torbenj
Yeah, it works. But actually it's not solution but rather a work around. Since lib supports text+arg format it should also handle such case correctly i guess. I'll try to contribute some fixes when have some free time (wanted before, just forgot tho)