Dapper.Aggregator 2.0.3

Criteria Pattern

var query = new Query<EventTable>();
query.Join<EventTable, EventDetailsTable>("EventTableID", "EventTableID");
query.Join<EventDetailsTable, CodeTable>(parent => parent.CodeTableID, child => child.CodeTableCD);

//build criteria
query.Filter = query.Eq(x => x.EventTableID, 0) |
               query.NotEq(x => x.EventTableID, 1) &
               query.Between(x => x.EventTime, DateTime.Now.AddYears(-10), DateTime.Now.AddYears(10)) &
               query.In(x => x.EventTableID, 0, 10000) &
               !query.Like(x => x.EventTitle, "AAAAA", LikeCriteria.Match.Start) |
               query.LessThan(x => x.EventTableID, 100) &
               query.IsNotNull(x => x.EventTableID) &
               query.Expression(" EXISTS(SELECT 1 FROM EventDetailsTable WHERE EventTable.EventTableID = EventDetailsTable.EventTableID)");

query.GroupBy(x => x.EventTableID)
     .GroupBy(x => x.EventTime)
     .GroupBy(x => x.EventTitle)
     .GroupBy(x => x.Lockversion);

query.Having = query.Eq(x => x.EventTableID, 3);

query.OrderBy(x => x.EventTableID)
     .OrderByDesc(x => x.EventTitle);
     
var rows = sqlMapper.QueryWith(query);