The Reactor ORM framework for ColdFusion recently gained a useful feature called 'filters'.

Filters stand midway between using the built in object-based query language and 'rolling your own' methods using CFQUERY.

You can find more details here and download an SVN snapshot from http://svn.reactorframework.com/trunk/ or grab the latest archive from http://www.falkensweb.com/reactor.html.

The set of possible things to go in a filter will be expanded in future, to include time based things like 'from' and 'to' for instance.

Thanks to Mark Drew for developing this feature.