public Q WhereIn(string column, Query query)
{
return(AddComponent("where", new InQueryCondition
{
Column = column,
IsOr = getOr(),
IsNot = getNot(),
Query = query.SetEngineScope(EngineScope)
}));
}
public Q Where(string column, string op, Query query)
{
return(AddComponent("where", new QueryCondition <Query>
{
Column = column,
Operator = op,
Query = query.SetEngineScope(EngineScope),
IsNot = getNot(),
IsOr = getOr(),
}));
}
public Q WhereExists(Query query)
{
if (!query.Has("from"))
{
throw new ArgumentException(@"""FromClause"" cannot be empty if used inside of a ""WhereExists"" condition");
}
return(Add("where", new ExistsCondition <Query>
{
Query = query.SetEngineScope(EngineScope),
IsNot = getNot(),
IsOr = getOr(),
}));
}
