Hibernate:
    /* select
        marketRow
    from
        MarketRow marketRow
    where
        marketRow.product is not null
        and marketRow.product.productName like ?1 escape '!'
        or not length(marketRow.productFreeText) = 0
        and marketRow.productFreeText like ?1 escape '!' */ select
            marketrow0_.id as id1_0_,
            marketrow0_.product_id as product_3_0_,
            marketrow0_.product_free_text as product_2_0_
        from
            market_row marketrow0_ cross
        join
            product product1_
        where
            marketrow0_.product_id=product1_.id
            and (
                (
                    marketrow0_.product_id is not null
                )
                and (
                    product1_.product_name like ? escape '!'
                )
                or length(marketrow0_.product_free_text)<>0
                and (
                    marketrow0_.product_free_text like ? escape '!'
                )
            )