Mapping SQLite result columns back to their source `table.column` (opens in new tab)

Research: It would be neat if arbitrary SQL queries in 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 ) on the problem. It found several promising solutions - one using ctypes to access the SQLite...