{ create_date => [-and => {'>=' => $start_date}, {'<=' => $end_date}] } #### WHERE ( ( ( create_date >= ? ) AND ( create_date <= ? ) ) ) #### { 'users.userid' => [-and => {'=' => 1000}, \'= drivers.userid'] } #### WHERE ( ( ( users.userid = ? ) AND ( users.userid = drivers.userid ) ) )