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
_______________________________________________
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