On Mon, Apr 1, 2019 at 7:15 AM Shane Dev <devshan...@gmail.com> wrote:
> [...]. By "dynamically changing table", I meant the number of columns and > rows could could change > after the dependant view was created. it appears this is impossible using > only SQL > It's possible using a virtual table, which years ago a colleague used in our app. I can't seem to find that one, but I found another here: https://metacpan.org/pod/SQLite::VirtualTable::Pivot I don't see anything related to pivot/transpose in either usual locations below: https://www.sqlite.org/src/dir?ci=6cf8b18ec20f11c2&name=ext/misc https://www.sqlite.org/contrib _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users