Engineer(s): Slav Babanin, Valentin Kavalenka 2025-12-18: What was accomplished since the last update: HIBERNATE-140 implemented and moved to review to enable testing Hibernate across multiple Java versions. Started designing an approach for emulating ternary logic in MQL to preserve query semantics/compatibility; explored limitations, constraints, and options. Investigated existing products (e.g., MongoSQL) and how their AST translation and “algebralizer” work. Built a simple POC 3VL translation using $expr for simple queries. What’s the focus over the next two weeks: Explore ternary logic handling for GROUP BY, joins, aggregate functions. Create compatibility tests against Postgres and MongoDB to validate equivalent behavior. Evaluate feasibility of De Morgan rewrites and treating UNKNOWN as FALSE in predicate contexts; test fallback to ad-hoc $expr where rewrites don’t apply. Test performance and analyze index usage differences between 3VL MQL and 2VL MQL translations. Any risks/blockers/impediments: None.