How to use Apache calcite LIKE_REGEX

I would like to use LIKE_REGEX in Apache calcite SQL query and can not find any documentation or examples on how to use it. Can you please share examples or documentation around it's usage.

Solution

LIKE_REGEX was introduced in the SQL:2008 standard but as of version 1.17 Calcite does not currently support it. (If you look at Calcite's SQL reference, LIKE_REGEX appears in Calcite's list of reserved SQL keywords because Calcite automatically reserves keywords listed in the SQL standard.)

If you would like to match regular expressions, use SIMILAR TO. For example, the query VALUES 'abcccd' similar to 'ab*c+d' returns TRUE.

Calcite's implementation of SIMILAR TO has semantics similar to PostgreSQL's implementation.

Perl Regex fails to compile looking for \object
Test if elements in a character string could be numeric
How to remove all but emojis in a (Javascript) string?
How to remove all characters from string apart from emoji
How can I find all matches to a regular expression in Python?
Zip code validation to exclude some formats
How to allow specific words using javax.validation.constraints.Pattern?
Create array of regex matches
Handling complex parentheses structures to get the expected data
Catching optional content just after a new line
Regex to compare strings with Umlaut and non-Umlaut variations
How can I check when there are only opening or closing quotes in PHP to make replacements?
Regular Expression | Leap Years and More
Regex date format validation on Java
How can I replace every instance of a character from 3 groups of characters with just 3 different characters respectively?
Regex to match 1 or less occurrence of string?
Getting parts of a URL (Regex)
Trim trailing spaces before newlines in a single multi-line string in JavaScript
Only keep this String in Notepad++ (Regex)
Redirect Youtube channel main page to videos section the proper way using regex
Regular expression to validate repeating comma-separated groups without trailing comma
Angular regex validator allows empty value, while the regex clause should demand at least one digit
Parsing DeepDiff result
Rewriting HTTP url to HTTPS using regular expression and javascript
regex to match HTML <p ...> tag starting with a lowercase letter
String.split() *not* on regular expression?
How can I find the last occurance of a dot not preceding with a slash?
How to extract table names and column names from sql query?
How to use Rust regex on bytes (Vec<u8> or &[u8])?
How to validate email by whitelist domain regex