Proposal for a shorthand syntax that relieves the caller from building a SQL query fragment. Today you'd do:
$products = $product_factory->find_all(array(
'where_clause' => '`subcategory_id` = 1 AND `brand_id` = 2'
));
The desired syntax would be instead:
$products = $product_factory->find_all(array(
'subcategory_id' => 1,
'brand_id' => 2
));
The assumptions here are:
- The query always filters down, i.e. the columns are put in AND
- If the user passes
where_clause, all shorthand column params are ignored.