It was sadly hinted as a recent or non standard feature by Github's syntax highlighting not recognizing it either

As I understand it, it's not part of the SQL standard.

Snowflake, Databricks & Terradata support it, it’s very useful in data warehouses.