News for hackers. Stuff that matters.
Re:PRQL, Pipelined Relational Query Language by zX41ZdbW on Tuesday July 25, 2023 @05:33PM (#36869885)
Both complaints are resolved by ClickHouse.

This video also covers many other advantages of ClickHouse's SQL dialect: https://www.youtube.com/watch?v=zhrOYQpgvkk

Some may find your first complaint questionable... But I specifically designed ClickHouse SQL to allow aliases to be used and referenced in every part of SQL query.

Re:PRQL, Pipelined Relational Query Language by jdmichal on Tuesday July 25, 2023 @10:00PM (#36872264)
So unsurprisingly based on my gripes, we are an OLAP shop. I've never heard of ClickHouse before, and I'll be looking into it. We're doing OK on PostgreSQL, but just OK. A lot of learning and unlearning.