Add support for ALTER TABLE REMOVE COLUMN for the removeColumn method for SQLite

[clearazil]

Issue Creation Checklist

• I understand that my issue will be automatically closed if I don't fill in the requested information
• I have read the contribution guidelines

Feature Description

Describe the feature you'd like to see implemented

I noticed that Sequelize drops tables (and recreates them with the data) with SQLite when using the changeColumn and removeColumn methods:
https://sequelize.org/docs/v6/other-topics/query-interface/#changing-and-removing-columns-in-sqlite

I don't think SQLite has added support for changing a table, but support for ALTER TABLE DROP COLUMN has been added since version 3.35.0:
https://www.sqlite.org/releaselog/3_35_0.html

Describe why you would like this feature to be added to Sequelize

SQLite now supports removing columns.

Is this feature dialect-specific?

• No. This feature is relevant to Sequelize as a whole.
• Yes. This feature only applies to the following dialect(s): SQLite

Would you be willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time and I know how to start.
• Yes, I have the time but I will need guidance.
• No, I don't have the time, but my company or I are supporting Sequelize through donations on OpenCollective.
• No, I don't have the time, and I understand that I will need to wait until someone from the community or maintainers is interested in implementing my feature.

---

Indicate your interest in the addition of this feature by adding the 👍 reaction. Comments such as "+1" will be removed.

[WikiRik]

Thanks for letting us know this is a possibility now!
For the person that will be working on this in the future; do note that removing a column that is a PRIMARY KEY or has a UNIQUE constraint cannot be dropped with this syntax, as per the docs. So in some cases the old workaround still needs to be used.