Upon reading "Programmers are cautioned not to use the two exceptions described in the previous bullets" at http://www.sqlite.org/lang_keywords.html, the goody two-shoes in me thought, I would like a pragma that disables those exceptions, i.e. a "strict quoting" pragma. Then I could use that pragma to assure myself that I was not inadvertently taking advantage of those exceptions.
Perhaps it might also be nice to have an "always quote" pragma, which requires that anything that can be quoted is quoted. Then I could use that pragma to assure myself that my generated SQL is immune to a change of identifier from something that doesn't need a quote to something that does, i.e. user_id to user-id. E.g. to assure myself that I have called Perl's $dbh->quote_identifier where appropriate. This assumes that my generated SQL is intended to be "dumb" or conservative, in that it quotes everything regardless of whether it needs to be quoted. Is this kind of pragma hard to make because it changes the language syntax, and the language syntax is assumed to be fixed? So would they in fact have to be a compile option, not a pragma? Thoughts? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
