Mapping SQLite result columns back to their source `table.column`
Simon Willison used Claude Code (Opus 4.8) to find methods mapping SQLite result columns back to their source table.column.
“I decided to set Claude Code (Opus 4.8, since Fable is currently banned by the US government) on the problem.”
Simon Willison explored using Claude Code (Opus 4.8) to programmatically map SQLite query result columns back to their originating table.column, surfacing solutions via apsw, ctypes against the SQLite C API, and EXPLAIN output interrogation. It's a useful engineering note for Datasette but a niche technical exploration rather than a major AI industry signal, with a passing mention that Fable is banned by the US government.