routine to fetch object data using a custom query This function uses dynamic run time determination of class types, fields.
Get the single result from the database
This function uses dynamic run time determination of class types, fields. The first type passed is used for basis for join, the table it is joining with has to have the id of the first one embedded. It creates associations via identity fields. The objects need to have an accessor method for the associated type, so that it can work even if it is not populated through the Items class.
routine to perform a count based on a custom query