Databricks SQL adds MATCH_RECOGNIZE operator for sequence pattern detection

Databricks SQL now includes the `MATCH_RECOGNIZE` operator, available in Public Preview, which introduces regex-like pattern matching for rows. This new operator simplifies the detection of sequences and patterns within event data, a task often challenging with standard SQL. It allows users to express complex temporal and sequential logic directly in a single SQL clause, making it easier to identify trends in cybersecurity logs, financial data, e-commerce funnels, and IoT sensor streams. The functionality is available across Databricks compute environments, including Lakehouse Real-Time.