Get the latest tech news

SQL patterns I use to catch transaction fraud


The actual queries I run when I'm hunting fraud in transaction data. Velocity, impossible distances, suspicious amounts, merchant clusters, off-hours buys, and window functions.

None

Get the Android app

Or read this on Hacker News

Read more on:

Photo of SQL

SQL

Photo of SQL patterns

SQL patterns

Photo of transaction fraud

transaction fraud

Related news:

News photo

A SQL-Inspired Query Language Designed for Event Sourcing (2025)

News photo

SQL: Incorrect by Construction

News photo

DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser