public static IWhere Where(this Select select, string column, SqlOperator sqlOperator, object value)
{
Clause clause = new Clause(select.Parameters, column, sqlOperator, value);
return(select.Where(clause));
}
public static Select RightJoin(this Select select, string joinOn, string predicate)
{
return(Join(select, JoinType.Right, joinOn, predicate));
}
public static Select Join(this Select select, JoinType joinType, string joinTo, string predicate)
{
return(select.Join($"{joinType.ToString().ToLowerInvariant()} join {joinTo} on {predicate}"));
}
public static IWhere Where(this Select select, string column, object value)
{
return(Where(select, column, SqlOperator.Equal, value));
}