Lack of abstractions like (block-scoped) variables and lambda functions.

SQL is declarative and purely functional anyways, so implementing these is a no-brainer.