query => SELECT $fields FROM $table WHERE #conditions age_check => age > ?age gender_check => gender LIKE ?gender ... # actual call... $dbixprettyobj -> query ( { conditions=>"&age_check AND &gender_check", age=>18, gender=>'M', fields=> "name, id", table=>users } );