[DOCS]: journal and snapshot and migration files, woohoo!

### Enhancement hasn't been filed before.

- [x] I have verified this enhancement I'm about to request hasn't been suggested before.

### Describe the enhancement you want to request

Would be great if you guys could add something to your great documentation about the actual files generated. I think I have figured some of it out with the help of AI, but there isn't any docs on it only indirect discussions. I suspect its powerful to understand this.

I create my own tidy perfected table objects and generate migrations from that... but when I am developing, it gets messy fast. I don't necessarily want to add all columns at once to a migration for example, I might want to add 1 after the other getting the entire chain to work... but I obviously don't want to generate 10 migration files for production. Ideally I could roll back to prod state (currently git rollback of migration folder and drop tables local seems best bet), then regenerate. Ideally there would be safety in the drizzle config (or something) that doesn't allow dangerous stuff in a prod environment, but perhaps that's wishful thinking.

In the end, understanding how to modify the journal, snapshots and drizzle table I see in the DB might be the power user solution I lack... but you guys know better than I.