PYTHON-4802: add support for sqlmigrate

[timgraham]

Currently SchemaEditor doesn't log queries and thus the sqlmigrate command doesn't work.

Reference: Django's implementation

Also see: CollectionDebugWrapper

[aclark4life]

Currently SchemaEditor doesn't log queries

Django core's SchemaEditor doesn't log queries because … logging queries is not a feature of the Django core, correct? In other words, via the BaseSchemaEditor doc string its job is "emitting schema-changing statements to the databases" not logging them.

and thus the sqlmigrate command doesn't work.

Can you clarify the relationship between the SchemaEditor and sqlmigrate command? IIUC, "thus it doesn't work" includes the assumption we want to use some MongoDB-specific SchemaEditor implementation to log queries in order to output as_mql ?

[timgraham]

By "log queries" I mean appending to SchemaEditor.collected_sql. sqlmigrate gets its output from collected_sql.