sqlite-utils
sqlite-utils copied to clipboard
Query with duplicate output column names drop/overwrites duplicate colums
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.