Is there a capability for some implementation of SqlQuery to change/add WHERE CLAUSE dynamically?

It would be great to add ORDER BY and paging parameters in Web tier.