Comment by manuelabeledo

I’m having a hard time trying to understand exactly what you want to do, that cannot be done with SQL. Any concrete examples?

I personally rely on views to reuse base queries and then add filters on top of them.