sqlite DDL isn't transactional

[abe-winter]

• am taking advantage of all-or-nothing mode in postgres? (double check this)
• probably need to use a transaction in sqlite instead