Be able to see the DDL generated by migrations

[dantownsend]

Discussed in #514

^{Originally posted by theelderbeever May 16, 2022}
Throwing this out there as a possible suggestion. It would be potentially valuable to have an --sql option with the migration management where the output of piccolo migrations new --sql is a .sql file instead of using python code. This maybe useful in debugging and transparency into what will be run and how. I know of one other ORM that does this (Hasura) and it was nice to easily edit the migration.

[AliSayyah]

Hey @dantownsend
Can I have a try on this?
This option could help me out right now.

[dantownsend]

@AliSayyah Yes, that would be great.

We need to modify MigrationManager somehow so instead of running queries, it prints out the SQL.

https://github.com/piccolo-orm/piccolo/blob/master/piccolo/apps/migrations/auto/migration_manager.py

[AliSayyah]

@AliSayyah Yes, that would be great.

We need to modify MigrationManager somehow so instead of running queries, it prints out the SQL.

https://github.com/piccolo-orm/piccolo/blob/master/piccolo/apps/migrations/auto/migration_manager.py

Ok, thank you.

[dantownsend]

Fixed by #584