Create a testsuite for migration

[gianarb]

#383 (comment)

Those are two reports caused by a not that defined workflow around migration. We have to improve safeguards and migration validation, even via testcontainers if needed and with static checks.

• Write an integration test that runs all the migration and validate that they work ( this is in sandbox)
• Write a unit test that validates that new migration have the right ID and the right function name
• maybe we can use go generate for something here (I don't think it applies here)