Use go generate to embed migrations

This MR uses go:generate to embed migrations and moves db/migrations/ to migrations/ as it doesn't make sense to hide a top level package (migrations) within a folder which has nothing else (db).