I know sqlite has some general limitations with alter Columns/Tables.
But in other Tools like "DataGrip" the Script steps will be generated:
New Transaction with create temp table with modification the type
and copy Data and drop old table.
The life would be easier if
dbvis can generate this steps too...