[CALCITE-33] SQL parser should allow different identifier quoting

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Labels: github-import
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 07:50
• Updated: 18/Jun/14 07:51
• Resolved: 18/Jun/14 07:51

Description

SQL parser should allow different schemes for identifier quoting. The current built-in scheme uses double-quotes (like Oracle, Teradata, Postgres). We could also allow back-ticks (like MySQL) and brackets (like Microsoft SQL Server).

These settings should be at the session level. Stored SQL (e.g. views stored in the catalog) would need a way to store the settings they need.

Then people could easily tune Optiq to behave like their favorite database.

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/33
Created by: julianhyde
Labels: enhancement,
Created at: Tue Apr 02 23:08:20 CEST 2013
State: closed