...
ANSI SQL-92 (MIN): https://en.wikipedia.org/wiki/SQL-92; Advanced Data Types, Case statements, BASIC SQL
ANSI SQL-2003 (SatisfactoryRecommended): https://en.wikipedia.org/wiki/SQL:2003; SQL with window functions
ANSI SQL-2016 (BestMost): https://en.wikipedia.org/wiki/SQL:2016 ; SQL with JSON, prone to security and governance risk.
Modeling Considerations
HDS will be a multi layer cube (KS a multi layer cube? Isn't it just relational?) optimized for error free loading. The model will also provide business level views to assist with Business Requirements.
...