Hi David,
i did not see a problem with you current approach. It is simple you dislike
literal sql?
You could write the subselect as a dbic statement and call as_query() and
use it, see
https://metacpan.org/pod/distribution/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Correlated-subqueries
my $i
Hello gang!
I'm having trouble figuring out how to express one of my joins in
DBIx::Class.
The two tables involved and some relevant sample data are:
> select * from serviceplan_price;
+++---+---+-+
| id | serviceplan_id | type | value | effectiv