The syntax in the article desugars to the method calls you remember (which are the common HOFs). Since the calls are lazy, they can also generate SQL when asked to execute.
Wikipedia explains it better than I could http://en.wikipedia.org/wiki/Higher-order_function