Hacker News new | comments | show | ask | jobs | submit login

To respond to one point: In standard SQL you usually cannot assign variables, macros, subroutines, etc. to complex or repeating parts in order to break the logic and sequence down into more manageable parts.

SQL actually has a way to break queries down, at least MS SQL does. There are views (certain kinds of views are even updatable), inline table functions (aka views with parameters) and Common Table Expressions.

Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | Legal | Apply to YC | Contact