SQL is 43 years old – Here’s why we still use it today
SQL is good, but it shows its age. Today somebody should come up with something statically typed and more functional (meaning using lambda calculus as a starting point).<p>The biggest pain points of SQL (IMHO) are:<p>- lack of statically typing guarantees (for example, no guarantee that a certain table has certain column)<p>- bad capability to abstract over parts of the data model (for example, queries have to specify the table that they query)<p>Both of these can be resolved with use of good enough functional language. There are projects like that in the FP&#x2F;Haskell community (e.g. Ermine), but it&#x27;s fragmented.