Machine Learning Feature Engineering Pipeline

Develop an advanced SQL-based feature engineering pipeline for preparing machine learning training datasets. Create a series of complex queries that transform raw user interaction data into meaningful ML features, implementing window functions, statistical transformations, and feature normalization. Design a flexible stored procedure that dynamically generates feature matrices for different machine learning models, handling categorical and numerical data with advanced preprocessing techniques.