The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
 / 
DBIx-DataModel-3.11
River stage one • 3 direct dependents • 3 total dependents
12 ++
/ DBIx::DataModel::Schema::ResultAs::Subquery

NAME

DBIx::DataModel::Schema::ResultAs::Subquery - SQL and bind values in a form suitable for a subquery

SYNOPSIS

  # subquery to be used in an IN clause
  my $subquery = $source1->select(..., -result_as => 'subquery');
  my $rows     = $source2->select(
      -columns => ...,
      -where   => {foo => 123, bar => {-not_in => $subquery}}
   );

  # subquery to be used in a SELECT list
  my $subquery = $source1->select(..., -result_as => [subquery => 'col3']);
  my $rows     = $source2->select(
      -columns => ['col1', 'col2', $subquery, 'col4'],
      -where   => ...
   );

DESCRIPTION

Returns a ref to an arrayref containing \["($sql)", @bind]. This is meant to be passed to a second query, for example through the -in or -not_in operator of SQL::Abstract, or as a column specification in the select list.

When used in the form -result_as => [subquery => $alias], the alias is added as a column alias, following the syntax specified in "column_alias" in SQL::Abstract::More.