Advanced Portfolio Correlation and Risk Decomposition

Create a sophisticated SQL analysis that decomposes portfolio risk by calculating inter-asset correlations, systematic and idiosyncratic risk components, and conditional volatility. The solution should handle time-series financial data, compute rolling correlation matrices, and generate risk factor decomposition metrics. Include capabilities for handling different asset classes, managing missing data points, and producing both aggregate and granular risk insights.