Re:Ask HN: Does anyone else think SQL needs help?
by ttfkam on Monday September 12, 2022 @09:41AM
(#32810083)
https://madlib.apache.org/
https://docs.timescale.com/timescaledb/latest/how-to-guides/...
https://duckdb.org/2022/05/04/friendlier-sql.html
It's a shame that so many people regard SQL using the reference SQL92 spec when in fact that it is continually evolving and improving like any other language still in use.
Hell they even have a name for databases specialized for this usecase — OLAP
The problem is that databases, and SQL, are such a pain to extend and define sufficiently general operations that you don’t just have scipy in the database, and thus your complicated analytics have to be fully specified with the few rudimentary analytic functions that are actually provided to you.