sqlite generated columns break inserts and push
@sungodtemple▲ 0 net votes
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.