...
Calcite provides implementations of ‘LIKE’ / ‘SIMILAR TO’.
‘SIMILAR TO’ handles regular expression so we can just use this expression.
Supported regex is far from Java regex, so someone might still want to have a function for Java regex.
GetIf
It works like elvis operator, but predicate should be just a boolean value.
It’d be ideal to implement ‘CASE’ instead of using this.
...