Support arrays as parameters

[bridger]

I've got an array of strings I'd like to use as a single parameter for for a WHERE IN clause.

let documentIds: [String] = [....]

When I tried:

let selectCreationDates = Select(documents.creationDate, from: documents).where(documents.documentId.in( arrayOfParameters ))
connection.execute(select, parameters: [documentIds]) { ...

I got no result from the database.

I was able to workaround by making each documentId a separate parameter like so:

let arrayOfParameters: [Parameter] = documentIds.map { _ = $0; return Parameter() }
let selectCreationDates = Select(documents.creationDate, from: documents).where(documents.documentId.in( arrayOfParameters ))
// Notice that documentIds here is no longer wrapped in the parameters array
connection.execute(select, parameters: documentIds) { ...

This approach was a little counter-intuitive and seems less efficient.

This works as expected, but is vulnerable to sql injection attacks:

let selectCreationDates = Select(documents.creationDate, from: documents).where(documents.documentId.in( documentIds ))
connection.execute(select) { ...