<div dir="ltr">Robert, maybe you want "as_query" ? <br><br><a href="http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as_query">http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as_query</a><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, May 10, 2018 at 2:00 PM, Robert Rothenberg <span dir="ltr"><<a href="mailto:robrwo@gmail.com" target="_blank">robrwo@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">It looks like the only way to use multiple-column subqueries in DBIx::Class is to define a virtual view, e.g. the SYNOPSIS in <a href="https://metacpan.org/pod/DBIx::Class::ResultSource" rel="noreferrer" target="_blank">https://metacpan.org/pod/DBIx:<wbr>:Class::ResultSource</a><br>
<br>
If there is a better way to do this, I haven't found it online.<br>
<br>
Assuming that is the way... I am wondering if it's possible to create a new result source class at runtime (and if so, how).<br>
<br>
My thinking is that given a resultset, use that information to create a new result class that can be used as a result source (e.g. subquery).<br>
<br>
<br>
<br>
<br>
<br>
______________________________<wbr>_________________<br>
List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" rel="noreferrer" target="_blank">http://lists.scsys.co.uk/cgi-b<wbr>in/mailman/listinfo/dbix-class</a><br>
IRC: <a href="http://irc.perl.org#dbix-class" rel="noreferrer" target="_blank">irc.perl.org#dbix-class</a><br>
SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" rel="noreferrer" target="_blank">http://dev.catalyst.perl.org/r<wbr>epos/bast/DBIx-Class/</a><br>
Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" rel="noreferrer" target="_blank">http://www.grokbase.com/group/<wbr>dbix-class@lists.scsys.co.uk</a><br>
</blockquote></div><br></div>