[Feature] Support SQL Mode: ANSI_QUOTES

[lucienlgl]

Search before asking

• I had searched in the issues and found no similar issues.

Description

Can we support the following SQL modes, similar to those in MySQL?

• ANSI_QUOTES: Treat " as an identifier quote character (like the quote character) and not as a string quote character. You can still use to quote identifiers with this mode enabled. With [ANSI_QUOTES] enabled, you cannot use double quotation marks to quote literal strings because they are interpreted as identifiers.

From: https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html#sqlmode_ansi_quotes

Additionally, the SQL modes supported by Doris differ significantly from those of MySQL. Is there a plan to gradually support these modes?

Use case

Related issues

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct