Mapping SQLite result columns back to their source `table.column`
Simon Willison explores methods to programmatically map SQL query result columns back to their source table.column, aiming to enhance Datasette with per-column metadata. Using Claude Code, he found solutions via the apsw library, SQLite's C function sqlite3_column_table_name() accessed through ctypes, and EXPLAIN output analysis.