Whenever you use a third-party tool/wrapper (such as SQLite Studio or some (unspecified) Python wrapper), be aware that they will (almost always) not be using your CLI instance of SQLite. [The docs](https://www.sqlite.org/lang_update.html#update_from) state that the `UPDATE ... FROM` variant was only introduced in version 3.33.0 of SQLite, so run: ```sql select sqlite_version() ; ``` from within SQLite Studio and/or through Python to see what version of SQLite _they_ are using.