Ongoing research is focused on developing methods to map SQLite result columns back to their original `table.column` sources. This innovation could allow tools like Datasette to display SQL query results with enriched provenance, improving data understanding and debuggability.
Source: Simon Willison