SQL migrations should be written in plain DDL/DML, without any SQL abstraction layer.

You will thank me when you'll have to figure out a migration gone sideways in-flight, and won't end up debugging the SQL abstraction.

Also, thanks IntelliJ for allowing me to highlight the DB connections before I mess something up gloriously.

I really don't like getting close to customer data manually.

@ocramius oh nice. How do you get IntelliJ to do that? (I’m guessing your regular user only has read access on prod though. Right?)

@Kynx my regular user does **not** have production access, luckily.

As for how to do that: