Are Hibernate filters only applied after the data has been loaded from db?

I've found some contradicting information on the net. Does anyone know whether Hib开发者_开发技巧ernate filters affect the generated sql, or is it just filtering the data as it's read from the database?

---

Hibernate filters affect the where clause of the generated SQL.

The Introduction to Hibernate Filters is a nice article on filters and provides a demo application allowing to play with them.

---

If you enable SQL in Hibernate using show_sql"(+"format_sql"), and execute query with enabled filter, you will see the result.

For example:

select
    item0_.ID as ID0_     
from
    ITEMS item0_ 
where
    item0_.deleted = 'FALSE' <-- here is filtering