[CALCITE-1115] Add support for translate (expession, from_string, to_string)

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.7.0
• Fix Version/s: 1.8.0
• Assignee: Julian Hyde
• Reporter: Arina Ielchiieva
• Created: 01/Mar/16 08:26
• Updated: 12/Jun/16 07:44
• Resolved: 03/May/16 22:06

Description

Calcite follows the standard SQL reference.
SQL reference, ISO/IEC 9075-2:2011(E), section 6.30

<character transliteration> ::=
TRANSLATE <left paren> <character value expression>
USING <transliteration name> <right paren>

Need to add support for translate (expession, from_string, to_string) alternative syntax.
Ex: Add the Oracle-style TRANSLATE function to SqlStdOperatorTable
(call it say TRANSLATE3, since it has 3 parameters)