class Product {
  public int productid;
  public string name;
  public string description;
  public DateTime available_since;
}

QueryBuilder qb = new QueryBuilder("products");

// The column with the "available_since" date is called "since" in the DB,
// so we will need to treat it a little differently
qb.AddColumnsOf<Product>(x => x.productid, x => x.name, x => x.description);
qb.Select("since AS available_since");

// Let's apply some filters
qb.Where(Cond.IsNotNull<Product>(x => x.name))

// Our Postgres text search too! Searching for descriptions with the words "porcelain" or "vase". This class's interface
// does not yet have a strongly typed constructor (check the string with the name of the field: "description").
// Calling "Where()" again ANDs this next condition with the entire previous one.
var tsvector = new TsVector("english", "description", true);
var tsquery = new TsQuery("english", "porcelain | vase", false);
qb.Where(SqlBuilder.Postgres.FullText.Match(tsvector, tsquery));

// Let's create one last condition just to illustrate a concept. If you want to compare two columns, you must call  
// ToSqlFragment() on one of them. This is an anti-programmer precautionary measure: if you want to compare 
// a column to a string, the current API will treat the string as a query parameter and not as a column to avoid 
// SQL Injection issues. If you want to compare two columns, you will have to be explicit. You still have to watch out to always
// use the first parameter as the column name and the second as the object, though.

// The condition is that we don't want products whose names are equal to their description
qb.Where(Cond.NotEqualTo("name", "description".ToSqlFragment()));

// Let's order by relevancy
qb.OrderBy(new OrderByFragment(new TsRank(tsvector, tsquery), OrderBy.Desc));

// And let's take only the results from 51 to 60
qb.Skip(50).Take(10);

// List the results! You have to have an open IDbConnection at this point.
List<Product> products = qb.List<Product>(openIDbConnection);