SQLite is quite SQL compliant

[Florian Weimer]

* Ravi:

> The documentation of the sqlite module at http://docs.python.org/library/sqlite3.html
> says:
>
> "...allows accessing the database using a nonstandard variant of the
> SQL..."
>
> But if you see SQLite website they clearly say at
> http://sqlite.org/omitted.html that only very few of the SQL is not
> implemented.

I think that page refers to SQL92, not some more recent version of the
standard.  There are also issues caused by SQLite's approach to
typing, e.g.

  SELECT 1 = '1';

returns a false value, where it would return true on other systems.

SQLite is a fine piece of software, but its SQL dialect has many
quirks.