search

simonw / sqlite-utils

Python CLI utility and library for manipulating SQLite databases
https://sqlite-utils.datasette.io
Apache License 2.0
1.58k stars 106 forks source link

Query with duplicate output column names drop/overwrites duplicate colums #624

Open andig opened 3 months ago

andig commented 3 months ago

Consider this join query:

select d1.*, d2.* from delta d1 inner join delta d2 where d1.new==d2.old

This will result in column names from d1, d2 to be duplicated. Unfortunately, running this query via sqlite-utils, only one set of output columns is returned, probably being overridden in the map.