I hadn't written SQL in 10ish years (while working in embedded, etc where I didn't need it.) and when I came back SQL had added the recursive stuff to the standard and OMG, is it ever awkward.
Their rolled out linear English-like syntax makes stuff like this so awkward, and this article is evidence of that, including the reach for the imperative style with the procedure and loops and so on.
I'd love for someone to rewrite the examples in here in Datalog (or RAI's "Rel") just to show how much clearer and brief they become.
Comments
I hadn't written SQL in 10ish years (while working in embedded, etc where I didn't need it.) and when I came back SQL had added the recursive stuff to the standard and OMG, is it ever awkward.
Their rolled out linear English-like syntax makes stuff like this so awkward, and this article is evidence of that, including the reach for the imperative style with the procedure and loops and so on.
I'd love for someone to rewrite the examples in here in Datalog (or RAI's "Rel") just to show how much clearer and brief they become.