This research explores mapping SQLite result columns back to their original table and column names. It investigates solutions using `apsw`, `ctypes` to access SQLite's C function `sqlite3_column_table_name()`, and `EXPLAIN` query analysis, aiming to enhance data provenance in tools like Datasette.
Opening Kapyn…