SQL Server understands bracket identifiers (in addition to the SQL Standard double-quoted identifiers), so these scripts are equivalent:
We'll extend the parser to understand bracket identifiers when sql_mode has the MSSQL flag.
Bracket identifiers will be accepted in all contexts where double-quoted identifiers are possible, including but not limited to:
- Direct SQL
- Dynamic SQL (PREPARE/EXECUTE/EXECUTE IMMEDIATE)
- Stored procedures
This will help SQL Server users to migrate to MariaDB easier.