Mapping SQLite result columns back to their source `table.column`

In three linesSimon Willison uses Claude Code (Opus 4.8) to solve SQL column provenance: programmatically identify the source table.column for each result in complex queries with joins and CTEs. Three solutions found: apsw, ctypes with sqlite3_column_table_name(), and EXPLAIN analysis.

Summary generated by Claude — human-verified