This is still alpha software, but it shows the idea; I still don't know when this work will be mature enough for a CPAN publication.
Two examples of virtual table modules are bundled with the distribution :
- FileContent : implements a virtual column that exposes file contents. This is especially useful
in conjunction with a SQLite FTS fulltext index; see the doc in Fulltext_search.pod
- PerlData : binds a virtual table to a Perl array within the Perl program. This can be used for simple import/export operations, for debugging purposes, for joining data from different
Thanks to Salvador Fandiño who pointed me to https://metacpan.org/pod/SQLite::VirtualTable, which is similar in idea but more meant to embed a Perl interpreter inside a sqlite application, rather than the other way around; this code helped me build the DBD::SQLite version.
Of course any comments/suggestions are welcome.