I remember the world before ORM (all queries inside data access objects) and it was not a great time to programming.

While I understand that ORMs have problems, I don't want to craft all SQL by hand and make myself a SQL builder because I need some optional filters.