MySQL in nodejs, syntax error, why?

Question

MySQL

mysql2 package.

await connection.query(
  'UPDATE files SET deletedAt = (?) WHERE key IN (?)', 
  [now, [keys]]
);

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key IN (('image/1562423492611.png'))' at line 1

What's wrong?

Answer 1

https://mariadb.com/kb/en/library/reserved-words/
You can use keywords as identifiers, but you must do it correctly. Better yet, don't use keywords for identifiers.