Exists, but without Correlated Sub query part, which is honestly a joke because of how subpair performance it usually have compared to other alternatives.
Can you remind, does SQL:2023 standard finally allow you to use DISTINCT keyword in WINDOW functions?
Or people still forced to do horrible hacks with correlated subqueries or joins to do extremely simple thing like count Distinct in running window of X days?
> it's basically impossible to write SQL to any degree of sophistication in Clickhouse.
Does exist.
> single-row SELECT with GROUP BY and HAVING clauses grouped views
If it's about grouping sets they do exist.
> no procedures
parametrized views/UDF/executable UDF (UDTF) exist.
> WHERE EXISTS,
Exists, but without Correlated Sub query part, which is honestly a joke because of how subpair performance it usually have compared to other alternatives.
Can you remind, does SQL:2023 standard finally allow you to use DISTINCT keyword in WINDOW functions?
Or people still forced to do horrible hacks with correlated subqueries or joins to do extremely simple thing like count Distinct in running window of X days?
> it's basically impossible to write SQL to any degree of sophistication in Clickhouse.
It's says more about engineer not DBMS.