How to handle plugin Schema migrations?

Hi guys. I was learning how to create plugins for kong using the python-pdk and it wasn't clear how to handle plugin schema migrations.

From what I understand about lua-pdk, to handle migrations, it's just need to create a migrations directory inside the plugin directory and write the migrations with raw SQL in files in the following format 000_<custom_name>.lua, and in the file init.lua, inside the migrations directory, which I believe is equivalent to python's __init__.py, is necessary to return a set with the filenames in the order they should be applied.

It seems to me that kong already handles the discovery of migration files, and to apply them just run kong's CLI (kong migrations up).

Does this whole process also apply to python-pdk?

Start by comparing the python-pdk plugin structure with the lua-pdk migration convention described in the issue: the migrations directory, numbered migration files, migrations/init.lua, and the kong migrations up CLI command. Document whether this process applies to Python plugins, including the expected migration file layout and how migrations are discovered and run.