Pass an array as parameter

[wsporto]

Hello,

It is possible to pass an array as parameter?
The query bellow returns the error: Error: Operand should contain 1 column(s).

const ids = [1, 2, 3];
return client.query('SELECT * FROM mytable WHERE id in (?)', [ids]);

[stLmpp]

Try it without the parentheses

const ids = [1, 2, 3];
return client.query('SELECT * FROM mytable WHERE id in ?', [ids]);

[wsporto]

Thanks for your feedback.

Without the parenthesis works, but I have some problems:

1. The query SELECT * FROM mytable WHERE id in ? is not a valid SQL according the MySQL grammar.
2. I can’t have a query like that: SELECT * FROM mytable WHERE id in (99, 100, ?)

I am using this library in my project (typesql) where I parse the query following the MySQL grammar.