SQL is not Designed for Analytics
6 min readNov 5, 2023
It sounds like a hot take. But does a language created more than 30 years ago is still relevant to our analytics need?
SQL was designed for OLTP (Online Transaction Processing). For CRUD operations (Create, Read, Update, Delete).
In the advent of data analytics, we now use SQL to transform data. To create ad-hoc analysis. To create business intelligence dashboards.