[Dbix-class] What's the best way to join with an aggregated query in DBIC

[Veesh Goldman]

have you tried ->as_subselect_rs? That should be what you're looking for.
Just make sure to define your "columns" on the subselect, or else it will
try to get all the cols from the original table.

On Wed, Jan 27, 2021 at 1:22 PM Robert Rothenberg <robrwo at gmail.com> wrote:

> I have an aggregated query
>
>    $rs->search_rs( undef, {
>      columns => [
>        "me.id",
>        { total => \ "SUM(me.val)" }
>      ],
>      group_by => [ "me.id" ],
>    } );
>
>
> I would like to join the results with another table, but that requires
> adding the columns to the group by clause.
>
> It's faster to do something like
>
>     SELECT a.*, y.* from (select id, sum(val) from x group by id) a join y
> on a.id=y.x_id
>
> Is there a way in DBIC to do that, without creating a virtual result
> source?
>
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive:
> http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20210127/d1286590/attachment.htm>