Re: "Standard SQL" ?
Chris Brody <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CAAAPFfHdO0baF31qyPo3NTqsyLxid71b3i3tm3a4ZsFyUE+z6g@mail.gmail.com> |
A few resources I found from https://www.google.com/search?q=sql+standard : - https://en.wikipedia.org/wiki/SQL - https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/#gref - https://dev.to/0xcrypto/who-owns-the-sql-standard-76m - https://modern-sql.com/standard - https://docs.oracle.com/cd/B28359_01/server.111/b28286/intro002.htm It seems to me like the last ANSI standard was published in 2016. It sound to me like implementors would generally implement a ``common SQL subset'' or ``common subset of the ANSI SQL standard''. My (US) $0.02 worth. On Thu, Jan 30, 2020 at 2:20 PM Simon Slavin <[email protected]> wrote: > I would appreciate your help. Reading a technical article today, I came > across a casual reference to "Standard SQL" as if it was a well-known > thing. This worried me since I've never heard the term and I'm meant to > know about such things. > > It doesn't seem to refer to the official standard for SQL, which is huge > and contains a plethora of features implemented once or never. The author > seemed to think it was a sort of 'core SQL' – features identically > implemented by all, or most, of the well-known SQL engines. > > The one possibility I can think of is SQL:1999. This is the first version > which has features marked as 'mandatory' or 'optional'. A full > implementation of all mandatory features could, I suppose, be called > "Standard SQL", but I've never heard of that term being used for that. > > Have any of you been using this term for a meaning other than "Fully > conforming to SQL:2019 (or whatever version you think current) ? Do you > have documentation somewhere ? Or are my suspicions correct and there's no > such thing ? > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users