At Prisma, the "twelve easy steps" for performing a table change in SQLite documented on https://sqlite.org/lang_altertable.html is a bit of a running joke.
SQLite is super versatile, but very different from other more traditional RDMBS.
SQLite is super versatile, but very different from other more traditional RDMBS.
The natively supported statements are as easy to perform as in MySQL or Postgres, for example.
> "The only schema altering commands directly supported by SQLite are the 'rename table', 'rename column', 'add column', 'drop column' commands shown above. However, applications can make other arbitrary changes to the format of a table using a simple sequence of operations.