RUST SDK How to insert an array of data with ON DUPLICATE?

[Rushmore75]

I see that using the db.insert()... you can insert an array of data, but how do that using db.query()...? I need to do this because I have custom ON DUPLICATE KEY UPDATE logic that I need to run. I've tried using .bind to insert multiple but that doesn't seem to work as it produces Failed to insert array: Db(InvalidQuery(RenderedError { errors: ["Unexpected token a parameter, expected ("], snippets: [Snippet { source: "INSERT INTO website (site, cralwed) VALUES $array", truncation: None, location: Location { line: 1, column: 44 }, offset: 43, length: 6, label: None, kind: Error }] }))

[Rushmore75]

Because

let _: Vec<Thing> = db.insert("website").content(all).await.unwrap();                                                                                                                                                                                                                                                                                                                                                             

works, except that I need custom logic on it.

match db.query("INSERT INTO website (site, cralwed) VALUES $array
ON DUPLICATE KEY UPDATE
accessed_at = time::now(),
crawled = crawled OR $input.crawled;
")
.bind(("array", all))
.await
{ ... }

This doesn't work, as it crashes with the above error

[Rushmore75]

Alright, here's working code:

db.query("INSERT INTO website $array
ON DUPLICATE KEY UPDATE
accessed_at = time::now(),
crawled = crawled OR $input.crawled
RETURN VALUE id;
")
.bind(("array", all)).await;