Do you have any specific SQL query in mind, that you want to execute?
A simple example is to get all past orders:
myPredicateExpression.Add(OrderFields.OrderDate < DateTime.Now);
Where you have to use the predicate expression in a fetch method, as shown in the docs.