教你三种方法追溯SQL列来源
Simon Willison 探索如何将任意 SQL 查询结果列映射回其源表.column。他尝试了三种方法：使用 apsw 库、通过 ctypes 调用 SQLite 的 sqlite3_column_table_name() C 函数（Python 未直接暴露），以及解析 EXPLAIN 输出。Claude Code (Opus 4.8) 帮助找到了这些方案。该功能旨在增强 Datasette 的 SQL 查询结果展示。
Mapping SQLite result columns back to their source `table.column`
Research: Mapping SQLite result columns back to their source `table.column` It would be neat if arbitrary SQL queries in Datasette could be rendered with additional information based on which columns from which tables were included in the results. To build that, we would need to be able to look at a SQL query like select users.name, orders.total from users join orders on orders.user_id = users.id and programmatically identify the table.column for each result - navigating not just joins but also more complex syntax like CTEs. I decided to set Claude Code (Opus 4.8, since Fable is currently banned by the US government ) on the problem. It found several promising solutions - one using apsw , another that uses ctypes to access the SQLite sqlite3_column_table_name() C function (which is not otherwise exposed to Python), and one using clever interrogation of the output of EXPLAIN . Tags: python , sqlite , datasette