DOOMQL implements a full ray tracer inside SQLite using a single recursive CTE query.

The rendering engine's ray tracing is accomplished via one large recursive common table expression in SQL. ✦ AI generated

Simon Willison · Simon Willison's Weblog · 2026-07-13 · original ↗

Here's the huge SQL query that implements a full ray tracer in SQLite using a recursive CTE.

Read full article ↗excerpt · fair-use quotation