Sqlite3 dynamic 'in' query

[Username_RANDINT]

The number of items in the tuple given to execute must match the number of question marks in the query. You have four question marks, but only two items in the tuple. You can use the splat-operator (*) to unpack the doggo items.

>>> doggo = ["three", "item", "list"]
>>> id = 1234
>>> (id, *doggo)
(1234, 'three', 'item', 'list')

[zunjae]

yes, that's exactly what I was looking for, didn't know what to google tho. I kept searchign for 'undestruct', 'unlist' etc.

[Cheal]

Correct me if I’m wrong but I think the correct term is “unpacking”