AISimon Willisonabout 4 hours ago
Mapping SQLite result columns back to their source `table.column`
1 min read
The author built a system to map SQL query result columns back to their source table.column using SQLite's sqlite3_column_table_name() C function via ctypes. This enables Datasette to render query results with additional table-specific metadata, even across joins and CTEs.
Level
Hype check
Tap to vote and see what everyone thinks.
