var connection = new SqlConnection("...");
var compiler = new SqlCompiler();
var db = new QueryFactory(connection, compiler);

var books = db.Query("Books").Get();

var books = db.Query("Books").WhereTrue("IsPublished").Get();

var introToSql = db.Query("Books").Where("Id", 145).Where("Lang", "en").First();

var recent = db.Query("Books").OrderByDesc("PublishedAt").Limit(10).Get();

var books = db.Query("Books")
    .Join("Authors", "Authors.Id", "Books.AuthorId")
    .Select("Books.*", "Authors.Name as AuthorName")
    .Get();

foreach(var book in books)
{
    Console.WriteLine($"{book.Title}: {book.AuthorName}");
}

var isFriday = DateTime.Today.DayOfWeek == DayOfWeek.Friday;

var books = db.Query("Books")
    .When(isFriday, q => q.WhereIn("Category", new [] {"OpenSource", "MachineLearning"}))
    .Get();

var page1 = db.Query("Books").Paginate(10);

foreach(var book in page1.List)
{
    Console.WriteLine(book.Name);
}

...

var page2 = page1.Next();

int affected = db.Query("Users").Insert(new {
    Name = "Jane",
    CountryId = 1
});

int affected = db.Query("Users").Where("Id", 1).Update(new {
    Name = "Jane",
    CountryId = 1
});

int affected = db.Query("Users").Where("Id", 1).Delete();