1) Prisma supports two workflows depending on whether you already have an existing database (introspection) or using Prisma Migrate. It sounds based on your description like something that would happen in the introspection workflow which this "re-introspection" feature resolves by retaining name mapping of relation fields.

3)

> For example, what if I want to `flush` my changes, and `rollback` or use a `savepoint` elsewhere.

That's not possible.

> It seems like everything is in the context of one call. Is that correct?

Not exactly, as you can batch multiple calls into one transaction guaranteeing that either all get committed or none. (https://www.prisma.io/docs/reference/tools-and-interfaces/pr...)