SQL Syntax when working with JS arrays

[zachcp]

I'd like to use an Array as a in input to a sql call. The array is coming from an Input.checkbox. Anyone have a suggestion on the best way to do this?

// doesn't work
const js_table = await sql`select * from table where col1 in ( ${array} )`

// doesn't work either
// [1,2,3].join() => '1,2,3'
const js_table = await sql`select * from table where col1 in ( ${array.join() } )`

[zachcp]

Looks like this is already here: #1088