Query:
SELECT * FROM TABLE WHERE lastName=? and firstName IN (?)
Values:
['Smith', ['John', 'Joe', 'Jon']]
Final query that runs in db is -
SELECT * FROM TABLE WHERE lastName='Smith' and firstName in ('{{John,Joe,John}}')
Expected query -
SELECT * FROM TABLE WHERE lastName='Smith' and firstName in ('John', 'Joe', 'Jon')
There was a function Vertica.quote in the vertica driver (https://www.npmjs.com/package/vertica) which used to work as expected.