The filter gets translated into SQL and executed. There should be no difference writing in SQL or using the Filter methods. Filter is provided to mimic the behavior of the UI and URLs, and sometimes it's more convenient to use programmatically than writing SQL.