On Mon, 21 Mar 2016 11:32:28 +0100
Dominique Devienne <ddevienne at gmail.com> wrote:
> > Explicitly documented by SQLite:
> >
>
> And? That's still non-SQL standard.
>
> SQLite tries to be compatible with non-standard extensions from
> various popular RDBMS', but when a standard alternative exists, it
> should be preferred IMHO.
Roger's APSW is SQLIte specific. It's pretty easy to imagine, isn't
it, that
char sql[] = "select [col] from [foo]";
is easier for him to use than
char sql[] = "select \"col\" from \"foo\"";
even if he's not using C?
I would certainly advise (and often do) anyone using SQL to learn to
distinguish between standard SQL and any given product's deviations
from it. Favoring standard constructs helps avoid weird corners and
style.
But machine-generated code inside a driver specifically for SQLite?
Hard to see who benefits, one way or the other.
--jkl
