WordPress
Implement altering column with `SET DEFAULT` and `DROP DEFAULT`
This PR implements the support for the following MySQL statements:
ALTER TABLE _tmp_table CHANGE name SET DEFAULT 'abc';
ALTER TABLE _tmp_table CHANGE name DROP DEFAULT;
It required a small refactor so that the CHANGE COLUMN logic can be extracted to a reusable method.
@brandonpayton I took another stab at this. It required extracting all the column-changing logic to a private method, and allowing edits to the columns via a callback, so that the old column definition is available to statements like SET/DROP DEFAULT. See the first two commits for that part. The third commit implements the new functionality. I tried to make as few refactors as possible, although some things could be done in a better way, I suppose, but then there would be even more refactor needed. These changes should also unlock reusing the same logic for other operations (e.g., DROP COLUMN).
I'm not sure if it's worth pushing this much further given that https://github.com/WordPress/sqlite-database-integration/pull/153 would change the translator quite a bit, and will likely be a chance to re-architect the translator a bit more.
