> Product asks for an email column, and because you like a tidy schema, you want it right after name

But why? SQL is supposed to be declarative, the whole point is that you don't need to care about such trivia. Only when you care about the order in a _result_ do you specify so.