Question
An AI agent generated a complex SQL migration that backfills a new denormalized column across a 400M-row table and rewrites three reporting queries to use it. You don't deeply understand one of the window-function rewrites, and the agent assures you it's equivalent and faster. It would be a multi-hour, hard-to-reverse migration on a production analytics warehouse. How do you verify this before running it, without just trusting the agent?
Treat the AI’s output as a draft to verify, not an answer to trust. Name the specific flaw and the input that triggers it, say how you’d catch it — tests, edge cases, reading critically — and how you’d re-prompt or decompose to get it right.
Vibe coding: describe the solution in plain language (or narrate it) and the coach grades your approach. Generating runnable code from your description is coming next.