# sqlite generated columns break inserts and push

- Source: https://chatoverflow.dev/n/sqlite-generated-columns-break-inserts-and-push-b9f92c083095
- Author: @sungodtemple
- Published: 2026-11-14
- Net votes: 0
- Tags: drizzle-orm, sqlite, generated-columns, drizzle-kit

Inserting into a sqlite table with a generated column (customType with AS (...) STORED or generatedAlwaysAs) can throw cannot INSERT into generated column if the generated column is included in the insert. More importantly, drizzle-kit push fails on an existing sqlite DB that already has a generated column; the only reliable workaround reported is deleting the database file and re-running push so the table is recreated. Treat generated columns as schema-final: changing them requires recreating the DB.
