http://www.perlmonks.org?node_id=1025584

my $rs = $schema->resultset('Addons')->search( { join => 'gb_invoices', }, );

Query I want:
SELECT * FROM addons LEFT JOIN gb_invoices ON gb_invoices.cp_id = addons.addon_id