build a a custom request for category view

hello many user want to modify a custom request to build a category view ...
but actualy we have too way
-hacking flexicore .... :evil:
-ordering after by php ... but it's become a slower solution for site performance ....
And with the field possiblity it's harder to insert custom field in core function....

for exemple now, in order to display some article how a custom date isn't out it's not possible by ...
only we can charging all of article and do an ordering by php comparaison... and pagination doesn't work ...

My idea
an advanced mode how we can do the sql request with admin interface in order to custom display...
in category admin in right panel a syntax systeme to do a sql request (for beginner user)
SELECT FROM[actualy categorie] is hide
a drop list with flexicontent filed (name,namefield)
an other drop list for WHERE option
an other drop list for AND option
an other drop list for <>= mathematique option
an other drop list ORDER BY option
an other drop list DESC ASC
an other drop list LIMIT option

it's possible ?
it's become a powerfull tools a lot user and site performance !!! a unique flexicontent fonction

Thanks for any helping