Re: [sqlite] AS being optional

2016-08-12 Thread Igor Korot
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

Re: [sqlite] AS being optional

2016-08-12 Thread Dominique Devienne
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

Re: [sqlite] AS being optional

2016-08-12 Thread Keith Medcalf
> 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. >

Re: [sqlite] AS being optional

2016-08-12 Thread Keith Medcalf
> 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

Re: [sqlite] AS being optional

2016-08-12 Thread Dominique Devienne
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.

Re: [sqlite] AS being optional

2016-08-11 Thread Keith Medcalf
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

Re: [sqlite] AS being optional

2016-08-11 Thread John McKown
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

Re: [sqlite] AS being optional

2016-08-11 Thread Richard Hipp
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