DataMapper ORM v1.8.2

[eluser]goddestroyer[/eluser]
lets say that our products are camera lenses. an example of a productspecifications are: objective size, focal length, max zoom... these are not stored as columns of the products table because the specifications themselves are variable (hence the specification_id in the productspecifications table).

furthermore, each specification may come in 3 flavors-- the value it has in the draft stage, the value it has in the engineering department, and the advertised marketing value, hence the "specificationsection_id" in our productspecifications table.

the application where the question arises, is suppose someone is searching for camera lenses and they check boxes that indicate they are only interested in lenses of objective size 50 AND max-zoom of 10.