How to bind an array of values?

[adamwulf]

I'd like to prepare an UPDATE query like so:

        let update = try conn.prepare("UPDATE records SET mumble = ? WHERE anyBlob IN (?)")
        update.run('grumble', arrayOfBlobs)

I only seem to be able to bind a single object, but don't see how i can filter the prepared query by an array of values?

[Zoxive]

My current workaround, a dynamic string of ? placeholders.

let stringOfReplaceableParams = Array(repeating: "?", count: locationIds.count).joined(separator: ", ")
do {
    try _db.run("UPDATE location SET received = 1 WHERE id IN (\(stringOfReplaceableParams))", locationIds.map { $0.value })
} catch {
    //
}