Data Integrity & SQL Fixes

Fixes

• Resolved multiple SQL issues:
  • Incorrect column references (pc_catid, facility_id)
  • Improper joins causing missing data
• Fixed OpenEMR SQL escaping errors related to dynamic table names (e.g., form_CAMOS)

Stability Improvements

• Removed unsafe dynamic SQL patterns
• Standardized query construction for better compatibility across OpenEMR versions