Discussed in #882
According to this SQLite's official document, "add column" with a primary key or unique key constraint, or having some kinds of server default needs the recreate style:
https://www.sqlite.org/lang_altertable.html#alter_table_add_column
code here we are changing is in sqlite.py