News for hackers. Stuff that matters.
Re:SQL Anti-Patterns You Should Avoid by wvbdmp on Saturday October 18, 2025 @01:34PM (#45629017)
No, sorry, you’re certainly correct, I just meant that any subqueries are generally crazy verbose. And then you usually want additional Where clauses or even Joins in there, and it starts to stop looking like a Where clause, so I’m often happy when I can push that logic into From.
Re:SQL Anti-Patterns You Should Avoid by Sesse__ on Saturday October 18, 2025 @01:38PM (#45629043)
Yes, I would certainly prefer if you could write

SELECT * FROM t1 SEMIJOIN t2 USING (x);

although it creates some extra problems for the join optimizer.

Re:SQL Anti-Patterns You Should Avoid by Little_Kitty on Saturday October 18, 2025 @04:04PM (#45630005)
It's great being able to use an any join (and the counterpart anti join) in Clickhouse to deal with these operations.