ARRAY_OVERLAP

SELECT ARRAY[1, 2] && ARRAY[3, 4]

create.select(arrayOverlap(array(1, 2), array(2, 3))).fetch();

+---------------+
| array_overlap |
+---------------+
| true          |
+---------------+

arrayOverlap(array(1, 2), array(2, 3))

-- AURORA_POSTGRES, COCKROACHDB, POSTGRES, YUGABYTEDB
(ARRAY[1, 2] && ARRAY[2, 3])

-- H2
EXISTS (
  SELECT *
  FROM UNNEST(ARRAY[1, 2]) array_table (COLUMN_VALUE)
  INTERSECT
  SELECT *
  FROM UNNEST(ARRAY[2, 3]) array_table (COLUMN_VALUE)
)

-- HSQLDB
EXISTS (
  SELECT *
  FROM UNNEST(ARRAY[1, 2]) array_table (COLUMN_VALUE)
  INTERSECT ALL
  SELECT *
  FROM UNNEST(ARRAY[2, 3]) array_table (COLUMN_VALUE)
)

-- TRINO
arrays_overlap(
  ARRAY[1, 2],
  ARRAY[2, 3]
)

-- ACCESS, ASE, AURORA_MYSQL, BIGQUERY, DB2, DERBY, DUCKDB, EXASOL, FIREBIRD, HANA, INFORMIX, MARIADB, MEMSQL, MYSQL, 
-- ORACLE, REDSHIFT, SNOWFLAKE, SQLDATAWAREHOUSE, SQLITE, SQLSERVER, SYBASE, TERADATA, VERTICA
/* UNSUPPORTED */