column-provenance

Tag

Cards List
#column-provenance

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

Simon Willison's Blog · 5d ago Cached

This research explores methods to determine the source table and column for each result column in arbitrary SQLite queries, using SQLite's internal column metadata API accessed via Python's apsw library or a ctypes bridge, with applications for tools like Datasette.

0 favorites 0 likes
← Back to home

Submit Feedback