Database management library in PHP?

Question

MySQL

Tell me the library in which I could establish a connection, conveniently:
Create / Delete a table, columns, indexes.
Without writing a query, nice with OOP.
Now I'm looking at Doctrine, but the question is whether it will be able to delete and change the names of the columns.
Ideally, to also read and write data through it later.
Thank you.

Answer 1

Doctrine2 (more precisely, doctrine-migrate) can diff between table mapping to objects and the existing schema itself. That is, if you have fields in the table that the object does not have, then it will generate SQL for the drop.

Answer 2

You can try phinx, it is very convenient, but in some places it can still be damp. Develops actively.