4 ms·
The issue here is that FROM, WHERE, etc., are all optional, where the operation (SELECT in this case) is not. If it were a proposal for a SQL21 standard to off
by BeefWellington 5y ago
The issue here is that FROM, WHERE, etc., are all optional, where the operation (SELECT in this case) is not.
If it were a proposal for a SQL21 standard to offer this as an optional method for query processing, I'd be all for it.
However, the idea of "non-optional followed by optional" came from an era where that sort of thing mattered and it made sense.