On Fri, Oct 25, 2019 at 9:50 AM <xxxxxx@ancell-ent.com> wrote:

The standard says so, but PostgreSQL case folds "unquoted names" to lower case, explicitly in violation of it: https://www.postgresql.org/docs/current/sql-syntax-lexical.html

Feh. SQLite, it turns out, supports quoted identifiers only in column aliases.

That page pointed out something else, namely that it's valid to say:

SELECT "SELECT", "select" from "Select" ...

But I say it's spinach, and I say the hell with it. I'm already covering far more than 80:20 here. I'm not even going to bother with dollar signs. I'll stick with the change I already made, because we don't want people writing create-table-foo anyway, but capitalizing keywords is for SQL (a case-insensitive language however you look at it), not for its S-expression image in a case-sensitive language.

John Cowan http://vrici.lojban.org/~cowan xxxxxx@ccil.org
I now introduce Professor Smullyan, who will prove to you that either
he doesn't exist or you don't exist, but you won't know which.
--Melvin Fitting