How to use the parameterized "IN" operator in prepared statments?

[h-sifat]

Sorry for bothering you guys. I'm trying to delete multiple records using the IN operator but it's not working.

Example:

const Sqlite = require("better-sqlite3");

const db = new Sqlite(":memory:");

db.exec(`create table if not exists categories(
  id integer primary key,
  name text not null,
  parentId integer default null
    references categories(id)
    on update cascade
    on delete restrict
);

insert into categories (name) values ('A'), ('B'), ('C');`);

const findAll = db.prepare(`select * from categories;`);

console.log(findAll.all());

const stmt = db.prepare(`delete from categories where id in ($ids);`);

const ids = [1, 2, 3].join(", ");
console.log(stmt.run({ ids }));

console.log(findAll.all());

Does better-sqlite3 not support parameterized IN operator? If it doesn't than should I delete records one by one inside a transaction?

Thanks in advance 💝

[Prinzhorn]

#283

[h-sifat]

#283

Thanks for the mention. I've got what I needed.
I actually tried to search the issues before opening this one but couldn't find one.