migration: Add additional docs
Created by: efritz
Split up existing SQL documentation into a directory. Move some of the migrations/README.md to docs so that we can point to it easily from CI when backcompat tests fail.
Fixes https://github.com/sourcegraph/sourcegraph/issues/25250.