| Subject: | SQL::Parser cannot handle quoted identifiers |
SQL (at least Microsoft ODBC and Oracle) allows double-quoted identifiers. That is,
SELECT "table"."field" FROM "table"
is valid. I've never run into a problem using it, and actually have my SQL-generating code quote things automatically as a habit because there always seems to be a field name which is a keyword for some database driver. (Quoting field and table names usually makes them acceptable.)
As an aside, Microsoft Access has a bizarre form of SQL that that allows the use of square brackets to quote things.
I have a program that generates really complicated joins. It would be nice to have a test script that uses an existing SQL parser to test if the SQL is valid. Even the simple SQL statements. Alas...