Apologies if this has been discussed before, I searched but couldn’t find it.
What is the rationale behind picking backticks for identifier delimiters in
spark?
In the [SQL 92 spec](
https://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt), the delimited
identifier is unambiguously defined to use double quotes; and lots of
databases/data warehouses accept this syntax:
<delimited identifier> ::=
<double quote> <delimited identifier body> <double quote>
<delimited identifier body> ::= <delimited identifier part>...
<delimited identifier part> ::=
<nondoublequote character>
| <doublequote symbol>
<nondoublequote character> ::= !! See the Syntax Rules
<doublequote symbol> ::= <double quote><double quote>
Is there any plan to accept double-quote delimited identifiers, at least when
ansi mode is turned on?
Regards,
Virgil.
