Relevant context & reading: > for most of the history of sql we did not know how to translate it to relational algebra, and now that we do know most databases

Relevant context & reading: > for most of the history of sql we did not know how to translate it to relational algebra, and now that we do know most databases still don't do it. https://www.scattered-thoughts.net/writing/unexplanations-sql-is-syntactic-sugar-for-relational-algebra/ https://www.scattered-thoughts.net/writing/unexplanations-sq... > None of this could be expressed in the original relational algebra, and once you add it all it's not obvious we should even still be calling this an algebra, let alone granting it any mathematical mystique. I'd settle for calling it the 'sql calculus'. Or 'the algebra formerly known as relational'. > It is still a reasonably good compiler IR though, and that's still the most useful way of thinking about it. https://www.scattered-thoughts.net/writing/unexplanations-relational-algebra-is-math/ https://www.scattered-thoughts.net/writing/unexplanations-re...