Shouldn't supportsAlterTableWithDropColumn and supportsAlterTableWithAddColumn return true?

[newdenim]

Hey, hope you are doing good. I was going to send a PR but I thought it's better to ask.

Is there a reason why the metadata returns false for supportsAlterTableWithDropColumn and supportsAlterTableWithAddColumn ?

I can execute these DDL without issues if I try, besides the known restrictions of sqlite. So it seems like these are supported operations.

Context:
I'm using Exposed for a project. I'm trying to implement migrations using Exposed Migration tools, and these tools use supportsAlterTableWithDropColumn to decide whether or not a migration should drop columns. So currently that is not working with this driver. Exposed PR.

So in short, is a valid bug or is there a reason why these methods should return false?.

Thanks!

[gotson]

seems like ALTER TABLE DROP COLUMN was added in 3.35.0, while ALTER TABLE ADD COLUMN was added in 3.2.0.

We would accept a PR for the change.

[newdenim]

Sorry for the delay. Busy day. Awesome, thanks. I'll send a PR asap.