On 27 Jan 2016, at 7:22pm, Yannick Duch?ne <yannick_duchene at yahoo.fr> wrote:
> By the way, another related question: the only reference for standard SQL I > have (which I have not read yet) is for SQL1992. Does this version of the > standard covers most of commonly used SQL or does it lack a lot of things? Or > alternatively, how far from or how close is SQLite to SQL92? Given what you wrote you should definitely read SQL1992. It is the core standard for SQL and you will find some ways in which SQLite is not SQL1992. However most SQL implementations implement most things in SQL1992. There are later standards for SQL and SQLite and other SQL implementations include some of the features in them. But at this point different implementations start to diverge from one-another far more. Simon.
