In the above code snippets, ignore

.withReadOnly(true) .with(CacheMode.IGNORE)

I was debugging and removing those does not change the generated SQL