[Dbix-class] Lateral and With / With Recursive

[Peter Rabbitson]

On 02/09/2015 08:11 PM, Bill Moseley wrote:
> Is there support and/or examples of usage of LATERAL and WITH in
> DBIx::Class?   Or it is limited to virtual views at this time?

There isn't currently support for these, due to the relatively low 
interest. Please refer to the discussion on the topic[1] and some 
preliminary related work[2] that never garnered enough tuits for API 
review (implementation wasn't a focus at the time).

You can *very much* help pushing this forward by kicking off review and 
comments on the API (both whether it acomplishes what's needed and how 
it relates to the existing Oracle implementation[3])

Cheers

[1] https://rt.cpan.org/Public/Bug/Display.html?id=39121#txn-781784
[2] 
https://github.com/dbsrgits/dbix-class/commits/people/dhoss/pg_with_recursive
[3] 
https://metacpan.org/pod/DBIx::Class::Storage::DBI::Oracle::Generic#ATTRIBUTES