Maybe support separate .sql files?

[nathanl]

Just a thought - large chunks SQL in YAML could get awkward. It might be nice to be able to break them out into .sql files.

Feel free to ignore my random bikeshedding. 😄

[piisalie]

I agree about the large chunks of SQL being unwieldy in YAML.

When you say 'break them out into .sql files' do you mean have .sql files that are referenced in the YAML migration file? Or just discard the entire YAML idea and use plain text files that get parsed somehow into the appropriate up/down sql?

[nathanl]

Personally I would generate a pair of SQL files ending with _up.sql and _down.sql and use those. But maybe it's too annoying to have to deal with two files per migration. I just like getting proper syntax highlighting and such.

Like I said, feel free to ignore me.