SQLite Update Query scenarios with 'no such column' scenarios Despite Column Existing
I'm working with a strange scenario when attempting to update a record in my SQLite database. My database schema includes a table called `users` with columns `id`, `name`, and `email`. The `email` column exists, but when I run the following update query, I receive a 'no such column: email' behavior: ```sql UPDATE users SET email = 'new.email@example.com' WHERE id = 1; ``` I've checked the schema using the `PRAGMA table_info(users);` command, and the `email` column is listed correctly. Here’s the output: ```sql id | name | email -- | ---- | ----- 0 | id | INTEGER 1 | name | TEXT 2 | email| TEXT ``` I also confirmed that there are no typos in the column name and that I've been using the same database connection throughout my application. I'm working with SQLite version 3.36.0 and using the `sqlite3` Python library. To troubleshoot, I tried to run the update query directly in the SQLite CLI and got the same behavior. I even attempted to re-create the `users` table with a different name and used the new table in my update query, but the same behavior occurred. Could this be due to a caching scenario or some other underlying question? I’ve also tried closing and re-opening the database connection, but the scenario continues. Any insights into what might be causing this behavior would be greatly appreciated! What am I doing wrong?