On top of the basic query syntax we're all used to, SQL databases tend to have a large number of built-in functions - some of which are standardized, some of which are unique to a particular database - and often the ability to write your own custom ones as well.
Now suppose we want to query a blog entry model for titles that are similar to a search string. We could do it like so:...
[
Collection
]
[
|
...
]