How does sqlAlchemy do the queries?
If I have one function like this:
```python
def search_users(query, page, per_page):
    return User.query.filter(
            func.lower(User.username).contains(query) |
            func.lower(User.email).contains(query) |
            func.lower(User.description).contains(query) |
            func.lower(User.forumUsername).contains(query) |
            func.lower(User.ircNick).contains(query) |
            func.lower(User.redditUsername).contains(query) |
            func.lower(User.twitterUsername).contains(query)
        ).order_by(desc(User.created)).offset((page - 1) * per_page)
```
And in another one I call it like this:
```python
users = search_users(query, page, 10).limit(10)
```
Would that `.limit()` be respected in the database read/query itself?
Or would it ask the database for _all_ rows first and then truncate them afterwards?