SQLite Forum

Generated Columns
Login
Looking at their [change log](https://github.com/pawelsalawa/sqlitestudio/blob/master/ChangeLog.md), SQLiteStudio 3.2.0 updated its embedded copy of SQLite to version 3.24.0, and there is no mention of a newer version of SQLite being included in SQLiteStudio 3.2.1. The [SQLiteStudio news page](https://sqlitestudio.pl/news/) says SQLIte 3.30 or 3.31 will be included in the next version, SQLiteStudio 3.2.2.

The most likely explanation for your problem is that SQLiteStudio 3.2.1 is unable to use the generated columns feature because it uses an embedded copy of SQLite which is too old. If you answer Larry's question (running the `SELECT sqlite_version();` statement inside SQLiteStudio), this will confirm whether my explanation is correct.

Most utilities that let you directly manipulate SQLite databases contain their own linked copy of a specific version of the SQLite engine. They don't use any external SQLite you might have (such as a DLL).

If you want a utility able to work on a database that has generated columns, you will either need to wait for a future version of SQLiteStudio, or use a different utility which already includes SQLite 3.31.0 or later (such as the latest SQLite command line tool).