It would be nice if the rows subcommand had a flag, perhaps called --transpose which would print in long form instead of wide. Similar to extended display mode in psql (\x)
$ for col in (sqlite-columns track_metadata.db songs)
sqlite-utils --fmt github track_metadata.db "select $col from songs order by rowid desc limit 5"
end
It would be nice if the rows subcommand had a flag, perhaps called
--transpose
which would print in long form instead of wide. Similar to extended display mode in psql (\x
)In other words instead of this:
The output would look something like this: