Complex Patient Risk Stratification Predictive Model

Develop an advanced SQL-based risk stratification algorithm using multiple medical data sources. Create a comprehensive query that: 1) Aggregates patient demographics, historical diagnoses, medication history, and lab results, 2) Implements machine learning-compatible feature engineering, 3) Calculates composite risk scores using weighted statistical models, and 4) Generates actionable patient segmentation for preventive interventions. Optimize the query for performance with indexing strategies and consider handling large-scale medical datasets.