[CALCITE-3147] BigQuery (standard SQL) quoting and identifier issues

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.21.0
• Assignee: Unassigned
• Reporter: Steven Talbot
• Created: 25/Jun/19 18:23
• Updated: 10/Sep/19 21:37
• Resolved: 06/Sep/19 03:13

Description

BigQuery escapes single quotes with backticks, and requires triple-quote quoting (like Python) when there is a newline. Also, it does not support the same set of characters in identifiers as other dialects of SQL. For example, it does not support '$'. Ideally, RelToSqlConverter (with the logic of the BigQuery dialect) would handle all this.