external user login far too slow due to previous diagnosis list query - separated into 2 queries and created request_status_view - much faster now

replaced Text::CSV::Slurp methods in L::L::ExcelHandler with a private _text_csv_slurp() method - uses Slurp::_from_handle() method + 0.901 mst patch to specify field-order

patched C::Patient::_personal_demographic_service() to supply flag for tt to skip PDS lookup for edits to anonymised patients (HIV, etc); combined some SessionStore methods into generic session_store_hashref() method

integrated date_contraints.tt with user stats; chnaged outreach interim report to show diagnosis & comment when authorised, not just reported; ScriptHelpers::mail_admin() accepts 'subject' arg

completed outreach overdue pack notification function; moved logic to skip if notification already sent from template to model; separated outreach worklists from other worklists; switched off PDS lookup for test scripts; patched validation_profiles/admin.t consistent with change to username validation

added gender to simple sql search list; minor cron tweaks

MAJOR CHANGE: moved sql_lib() from M::Base to new M::Role::Query; moved all M::R::QueryFormatter methods into M::R::Query; removed sql_lib() from ScriptHelpers - using new M::Roles::Query method; removed lims_dbix() from M::Base - now loaded via M::Role::DBIxSimple on demand; moved get_sql_with_constraint() from M::R::DBIxSimple to M::R::Query; method gets dbh from lims_db not lims_dbix in M::LabSection::update_lab_sections() & M::Specimen::update_specimens(); added elements() to Local::QueryLibrary