Adaptive Machine Learning Feature Engineering Pipeline

Construct a SQL-based feature engineering pipeline that dynamically transforms raw data into machine learning-ready feature sets. Create a flexible system that can automatically detect data types, handle missing values, perform feature scaling, and generate interaction features. Implement the solution using PostgreSQL's advanced JSON and array capabilities, ensuring the pipeline can handle varied input schemas and automatically adapt to new data sources.