no transactions on data description layer?

CREATE TABLE etc in SQLite are fully transactional, as are updates to PRAGMA user_version which you can use to store a logical schema version number. I built Notion’s SQLite migration system for client devices on those primitives.