So it seems DHH was inspired by the Sexy Migrations plugin (which in turn was inspired by Hobo) and committed changeset 6667.

Now, you can do this:

create_table :products do |t|
  t.integer :shop_id, :creator_id
  t.string  :name, :value, :default => "Untitled"
  t.timestamps
end

Succinct!