SQLite ambiguous error message

[stackedCG]

Hi Tauri devs, I have the following SQLite statements that have some weird error message:

WITH restock(added_quantity,barcode_serial) AS (
      VALUES ($1,$2),($3,$4),($5,$6),($7,$8),($9,$10),($11,$12),($13,$14),($15,$16),($17,$18),($19,$20),($21,$22),($23,$24),($25,$26),($27,$28),($29,$30)
    )

UPDATE products
SET products.quantity = products.quantity + restock.added_quantity
FROM restock
WHERE products.barcode_serial = restock.barcode_serial;

But upon running the query it keeps on showing this error:
Uncaught (in promise) error returned from database: (code: 1) no such column: updates.quantity

Now initially I have this setup before, but it mentions that quantity is ambiguous, which I replaced by using added_quantity and replaced updates table to restock

WITH updates(quantity,barcode_serial) AS (
      VALUES ($1,$2),($3,$4),($5,$6),($7,$8),($9,$10),($11,$12),($13,$14),($15,$16),($17,$18),($19,$20),($21,$22),($23,$24),($25,$26),($27,$28),($29,$30)
    )

UPDATE products
SET products.quantity = products.quantity + updates.quantity
FROM updates
WHERE products.barcode_serial = updates.barcode_serial;

Some work around I did are:

• Refreshing the app.
• Deleting the database to regenerate new set of database and table since it might have cached my previous error.

But none of it have worked. The only thing I have not tried is restarting my whole PC.

[stackedCG]

Also just a follow up, are Update ... IN clause, CTE, and Upsert possible to be used directly in sqlite plugin?

[stackedCG]

Oh I made it work now I forgot to add the Begin...Commit clauses on the sample it looks like I did not added ; at the end of begin and commit. Sorry my bad a big rookie mistake on my part lol