Six SQL patterns I use to catch transaction fraud
Summary
An actionable guide outlining six SQL patterns to detect transaction fraud, focusing on velocity, impossible travel, amount anomalies, suspicious merchants, off-hours activity, and composability with window functions. Emphasizes SQL-based detections over ML, with practical considerations for baseline, thresholds, and human review.