SQLite complex migrations

[jokull]

Semi-famously, SQLite has limited ALTER TABLE support, for example when changing constraints or types on columns. I haven't tested Atlas yet but wanted to ask if there's support for orchestrating complex migrations in SQLite via temporary tables or renamed columns?

The limitation and one type of workaround is described here.

[a8m]

Yes.

Here is a reference to the code in case you are interested: https://github.com/ariga/atlas/blob/master/sql/sqlite/migrate.go#L206