There are other methods to handle other SQL clauses.
Pretty much any standard SQL clause has a method that can be used to modify the clause.
The database adapters also add database-specific methods for handling database-specific clauses and actions.