What is the correct syntax for including SQL values AND rowsAsArray option in a query? #3095

Hi, @millerbryan 🙋🏻‍♂️

You can set it in both connection and query levels:

You can see the docs#array-results section for more details.

Thank you @wellwelwel - I saw those examples in the docs.

However, my question is how to set rowsAsArray in the query when I am also passing in SQL values to the query?

Please see my code snippet in the OP.

Is there a keyword for SQL values like this for SQL values?

try { 
   const [results, fields] = await conn.query({ 
     sql: 'SELECT 1 AS `foo`, 2 AS `foo`', 
     values: [state],
     rowsAsArray: true, 
   });