Re: [sqlite] AS being optional

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

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

> 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

> 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

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

t, 2016 08:57 > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] AS being optional > > Is there a reason why AS is optional, such that: > > select a b, c from x > > is equivalent to: > > select a as b, c from x; > > I agree it couldn't be cha

Re: [sqlite] AS being optional

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

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

[sqlite] AS being optional

Is there a reason why AS is optional, such that: select a b, c from x is equivalent to: select a as b, c from x; I agree it couldn't be changed now, but luckily I spotted that I had omitted a comma, before it was too late. -- Cheers -- Tim