WildFire NuGet Package

var queryBuilder = new QueryBuilder();
var t0 = new Table()
{
TableName = "Table0",
TableAlias = "t0"
};
var t1 = new Table()
{
TableName = "Table1",
Column1Name = "Column1",
Column2Name = "Column2",
JoinType = JoinType.Inner,
TableAlias = "t2"
};
////Create table from first table
//var tables = new List<Table>();
//tables.Add(t1);
//// Perform a join
//t0.JoinOn(tables);
queryBuilder.AddTable(t0);
////there are two ways you can add predicate either by string or predicate object
var textMatchExpression = new Predicate("t1.[Column3] like 'Joe'");
////AddPredicate also takes just string if you have only one where condition.
queryBuilder.AddPredicate(textMatchExpression, OperationType.And);
var datesExpressions1 = new List<string>();
datesExpressions1.Add("f.[Column5] >= '2015-09-01'");
datesExpressions1.Add("f.[Column6] <= '2015-12-31'");
var dateExpressions2 = new List<string>();
dateExpressions2.Add("f.[Column7] >= '2015-10-01'");
dateExpressions2.Add("f.[Column8] >= '2015-12-31'");
//add groups of predicates
queryBuilder.AddPredicate(datesExpressions1, OperationType.And, OperationType.Or);
queryBuilder.AddPredicate(dateExpressions2, OperationType.And, OperationType.Empty);
//Order by
queryBuilder.Query.OrderBy("Column1", true);
//Fetch overloaded with offset and number of rows.
queryBuilder.Query.FetchNext("2","20");
queryBuilder.GenerateQuery();.