Where querys

Is it possible to do a query with a where clause like in sql? If so would you mind providing some example code?
If not: that would be a really great enhancement.

[bengro]

I'm working on that for the table view. It will be possible to search by column criteria (supporting ==, <, >, LIKE operators) as well as sort the rows. The problem is, that I can only test it for MySQL adapter. Someone would have to enhance the queries for Postgres and MSSQL. I can induce a pull request if anyone is interested.