/ 
DBIx-DataModel-3.11
River stage one • 3 direct dependents • 3 total dependents
/ 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.