Quote table name in SQL exporter

[timtomch]

Quote table name in SQL exporter

[thadguidry]

I tend to agree. We should add a toggle to

• Use ANSI QUOTES

which once checked, would wrap double quotes around identifiers.
when unchecked, it would use backticks.

https://dev.mysql.com/doc/refman/8.4/en/identifiers.html

@timtomch And the default should be... unchecked, you think?

[tfmorris]

I changed "escape" to "quote" to follow common terminology.

It looks like there are at least three different conventions for quoting what SQL calls "delimited identifiers":

1. "ANSI Standard"
2. [MS SQL Server]
3. MySQL

In all cases, the quote character can be included in the identifier by doubling (ie escaping) it. I don't know if we have other uses of identifiers besides column names and table names, but, if so, they should follow the same quoting rules.

[timtomch]

Thanks for figuring this out! I think that despite MySQL being quite common, the default should still be the ANSI standard, no?