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

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