Supported

HQL row-value constructor predicates over multiple columns:

where (a, b) = (1, 2)
where (a, b) <> (1, 2)
where (a, b) in ((1, 2), (3, 4))

with either bound parameters or literals. Translated to per-component MQL:

• = → $and of per-field $eq
• <> → $nor of that $and
• in → $or of per-row $and

Today these throw FeatureNotSupportedException ("Expression not supported: SqlTuple" / "Only the following list predicates are supported: field in [not] (...)").

Out of scope

• Lexicographic ordering comparison (>, <, >=, <=) — separate ticket.

Precursor to HIBERNATE-207 (composite primary key), which reuses this decomposition for id predicates.