As the example at the start of the presentation showed, queries are built with method chaining.
Each clause in the SQL statement has an associated dataset method that affects that clause.