Whenever you're ready, walk me through how you'd approach this.
When would you use an after trigger versus a before trigger?
Explain the execution timing and practical tradeoffs between the two trigger types. Cover how each handles validation, modifying incoming row values, auditing, derived data, and side effects in PostgreSQL. Mention any important limitations or transaction considerations.