Electronic Health Record Complex Query Builder

Create a type-safe query builder for electronic health records using TypeORM that supports complex multi-table joins across patient demographics, treatment histories, and diagnostic records. Implement dynamic filtering mechanisms that allow clinicians to construct granular searches while maintaining referential integrity and performance. Include type-level safety checks to prevent invalid query constructions and automatically generate audit logs for each database interaction.