MySQL and MariaDB don't support limit in in predicate subqueries, so special casing limit 1 to use the = predicate would be necessary. This has to happen in com.blazebit.persistence.view.impl.objectbuilder.transformer.correlation.SubqueryCorrelationBuilder#correlate.