It seems that after ALTER TABLE .. RENAME TO, ADD COLUMN is probably
the most common, probably followed by DROP COLUMN. I'd like to take a
crack at adding support for ADD COLUMN. It seems that I can do this
via VDBE -- it seems similar to doing an UPDATE across the entire
table, reading the existing data, adding a null for the new column,
and putting the newly-extended record back into place; with a
schema/num columns update coming either before or after this
operation.
Would this be the right approach to take?
Thanks,
- Vlad