SQL is syntactic sugar for relational algebra

Re:SQL is syntactic sugar for relational algebra by mdcurran on Saturday March 23, 2024 @09:39AM (#39799851)

This doesn’t totally solve the issue of SELECT’ing first then filtering, but for complex queries I’ve found CTEs very useful (whenever the database/SQL dialect supports it).

[ Parent | on HN ]

Re:SQL is syntactic sugar for relational algebra by icedchai on Saturday March 23, 2024 @11:07AM (#39800478)

What I usually do is start with "select *", get the joins and where clause down, then refine the select.

[ Parent | on HN ]