Is it possible to pass an unknown number of values ​​to a sqllite3 query, without crutches?

Question

Python

Is it possible to pass an unknown number of values ​​to a sqllite3 query, without crutches?

cur.execute(
        """
        DELETE from item
        WHERE NOT name IN (?); 
        """
       (names,)
)
# вместо "?" должно подставится неизвестное количество параметров

Answer 1

Unfortunately no. The only way:

placeholders = ", ".join(["?"] * len(names))
sql = f"DELETE FROM item WHERE NOT name IN ({placeholders})"
cur.execute(sql, names)

Answer 2

As for sqlite, I'm not sure if it will work or not, but try
instead of (?) to make a selection (SELECT ...)