The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

SQLite::VirtualTable::Pivot::Cursor - a cursor for a pivot table query

DESCRIPTION

Objects in this class represent cursors for queries on pivot tables.

They maintatin a statement handle corresponding to an unpivotted query on the base table. The pivotting operation is done one row at a time, as data is returned; i.e. we order by the id, and group on the fly.

It must be possible for multiple cursors to exist at once on the same pivot table, in case it occurs more than once in a query.

SEE ALSO

SQLite::VirtualTable::Pivot