Dominick,
On Fri, Aug 12, 2016 at 9:24 AM, Dominique Devienne wrote:
> On Fri, Aug 12, 2016 at 2:42 PM, Keith Medcalf wrote:
>
>> [...] The main problem with the JOIN/ON syntax is that to a casual reading
>> order is implied
>
>
> No idea what you mean
On Fri, Aug 12, 2016 at 2:42 PM, Keith Medcalf wrote:
> [...] The main problem with the JOIN/ON syntax is that to a casual reading
> order is implied
No idea what you mean here :)
> ([...] ream of brackets [...]).
>
Nor what this has to do with JOIN/ON. Get off the
> I'm not a manager, and I do have a few "computer skills" (I think), and I
> still find JOIN ON much more
> readable than the FROM-comma + WHERE alternative. Helps me "thread" the
> table join in my head much better.
> Definitely helps me "grok" a statement faster, so not syntax sugar to me.
>
> AFAIK, AS is necessary in UNION, at least on some RDBMS, to have the same
> columns for all UNION'ed queries.
> So in that sense, not strictly syntax sugar. And it's of course valuable
> to
> give good names to complex expressions.
> A good name goes a long way to make "code" (of any sort) more
On Fri, Aug 12, 2016 at 2:55 AM, Keith Medcalf wrote:
>
> AS is optional as it was "syntactic sugar" added to SQL [...]
>
AFAIK, AS is necessary in UNION, at least on some RDBMS, to have the same
columns for all UNION'ed queries.
So in that sense, not strictly syntax sugar.
AS is optional as it was "syntactic sugar" added to SQL so that Managers and
others with no computer skills could read SQL too, just like the overriding
design principle of COBOL wasto be "so simple and english like that even
management could understand it". Having to end each statement with
That's the ANSI / ISO standard for the SQL language.
On Thu, Aug 11, 2016 at 10:02 AM, Richard Hipp wrote:
> On Thu, 11 Aug 2016 15:57 +0100, Tim Streater
> wrote:
> > Is there a reason why AS is optional
>
> Because that is what PostgreSQL does. (Also
On Thu, 11 Aug 2016 15:57 +0100, Tim Streater wrote:
> Is there a reason why AS is optional
Because that is what PostgreSQL does. (Also MySQL. Maybe others too.)
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing
8 matches
Mail list logo