implications of quoted_identifier in SQL

Quoted identifiers (i.e. identifiers surrrounded by double quotes) enable you to use names for identifiers which would otherwise be illegal such as reserved words or names which contain embedded spaces.

However, if you use them, then string literals must be enclosed in single quotes to distinguish them from quoted identifiers.