Describe the bug
We have a schema name like my-schema in MySQL. When querying this schema we are required to enclose it in backticks to escape the hyphen. It seems however that the SQL generated by SQL Provider does not contain backticks around schema or table names (although it does around column names).
In principle would it be possible to always wrap schema and table names in backticks to ensure they are properly escaped? If so I'm happy to submit a PR.
On a side note I think this might be the underlying cause of the other issue (#773) I opened about the missing Create(...) functions.
To Reproduce
Create a schema in MySQL that contains a - in the name and try to query it.
Expected behavior
The generated SQL should be more like:
Describe the bug We have a schema name like
my-schemain MySQL. When querying this schema we are required to enclose it in backticks to escape the hyphen. It seems however that the SQL generated by SQL Provider does not contain backticks around schema or table names (although it does around column names).In principle would it be possible to always wrap schema and table names in backticks to ensure they are properly escaped? If so I'm happy to submit a PR.
On a side note I think this might be the underlying cause of the other issue (#773) I opened about the missing
Create(...)functions.To Reproduce Create a schema in MySQL that contains a
-in the name and try to query it.Expected behavior The generated SQL should be more like: