catfan/Medoo — pull request #131 by JDubDev (2014-07-16 15:35:34+00:00)
Title: Select Queries in Where Clause

Adding option for Select Query to be used in Where Statement
Example

"AND" => [
"employees.company" => (object)['query'=>"(SELECT id FROM companies WHERE email = '".$email."')"],
],

Assuming in this example that companies.email is an unique field.

This would require the developer to use Medoo->quote when building these select queries to keep up the sql injection security feature built into Medoo. But it would allow select queries in the Where clause and avoid having to use a join.