On 1 Apr 2019, at 10:18am, Dominique Devienne <ddevie...@gmail.com> wrote:
> I can't seem to find that one, but I found another here: > https://metacpan.org/pod/SQLite::VirtualTable::Pivot I looked at that one, but it doesn't do what OP wants, which is to swap rows and columns without the programmer having to specify anything. It would be possible to implement the transform pivot as a virtual table in any language. But you do have to do the work: the feature doesn't come with SQLite. And if you're writing code you might as well do it in your program. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
