It's not you, it's SQL

Re:It's not you, it's SQL by eatonphil on Monday January 30, 2023 @02:53PM (#34585457)

On the other side of things, it's interesting to see SQL engines innovating. Though the only one I can name for sure is DuckDB: https://duckdb.org/2022/05/04/friendlier-sql.html.

Have other implementations done anything for making queries easier (that don't involve requiring an IDE or anything, so just query language innovations)?

Edit: Not query language innovations but ClickHouse and Snowflake's "standard library" of builtin functions just keep getting better and better. Once I saw `parseDateTimeBestEffort` in ClickHouse I wanted that everywhere...

[ Parent | on HN ]

Re:It's not you, it's SQL by jamwt on Monday January 30, 2023 @03:18PM (#34585772)

Article author here -- DuckDB is indeed cool.

Another interesting bit of work in this space is LINQ on the microsoft side of things. And even list comprehensions end up having a scanning/summing language kind of feel to them that would be interesting to see translated into a new database query language.

[ Parent | on HN ]

Re:It's not you, it's SQL by znaimon on Monday January 30, 2023 @05:41PM (#34587601)

+1 to ClickHouse builtin functions—they vastly simplify a lot of data analytics workloads

[ Parent | on HN ]