A new research project explores mapping SQLite result columns back to their source table and column. This capability would enhance tools like Datasette by providing richer metadata for SQL query results. The research investigates several promising programmatic solutions using Python libraries and SQLite's C API.
Opening Kapyn…