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.