Changes for version v3.3.0 - 2026-11-18
- pluck with no column gives the only one; the Sugar's pipelines, and sinks, are documented.
- pluck(), or pluck written bare, gives each row's only column, so a one-column query gives plain values without sub { $_->[0] } (roadmap 2026-0038). Still requires Ekorn::Pipeline >= v0.3.6, < v0.4.0.
- DBIx::Squirrel::Stages::Rows: pluck with no column gives each row's only column, counted from the row: an array of one element, a hash of one key, a row object of one column. So it needs no statement, and works in a select method's stages. A row of more columns, or none, croaks, "Expected one column to pluck, not 2", rather than give the first; pluck(0) gives the first. pluck(undef) and pluck('') still croak. It has no prototype, so pluck(@cols) is unchanged (roadmap 2026-0038).
- The docs' examples over a one-column query use pluck, where the stage did nothing else (roadmap 2026-0038).
- DBIx::Squirrel::Sugar's POD, and the reference's Sugar chapter, have a section on pipelines: calling the function each gets, and giving one to a single call with pipeline('name'). Both say the word pipeline comes from Ekorn::Pipeline::Factories or DBIx::Squirrel::Tooling.
- DBIx::Squirrel's POD says what a sink is, where sinks and sources come from, and that DBIx::Squirrel::Tooling exports them. Its list of Flow's stages has take_if and drop_if.
Documentation
DBIx::Squirrel user guide
DBIx::Squirrel reference
Modules
DBI, minus the boilerplate, plus a pipeline
what a stage can ask about the result it's making
report the DBI's errors at the caller's line
a stage made afresh for each run, told when the values run out
an iterator over a statement's results
find the placeholders in a statement, and match values to them
the base class of the rows a result set hands out
an iterator handing out rows as objects
stages gathering values: batch and collect
stages taking or dropping values: take, drop, take_first, take_last, take_single, take_while, drop_while, take_if and drop_if
stages reshaping rows: pluck and as_hash
stages run for their side effects: peek, count_into, dump_to and tee
end a DBIx::Squirrel pipeline early
a function for each database, and each statement
DBIx::Squirrel's stages, sinks and words, from one module
helpers shared by DBIx::Squirrel's modules
DBIx::Squirrel's database handle class
DBIx::Squirrel's statement handle class