Describe the bug

In packages/knex/src/AbstractSqlDriver.ts, the find function will check meta.virtual, and use findVirtual for virtual entity.

But cursor pagination part is under the return, it doesn't handle the cursor option, so we cannot fetch the correctly amount data.

Reproduction

minimal reproduction

expect:

select * from ( SELECT "user".id, "user".name, "user".age, COUNT(b.id) AS book_count FROM "user" LEFT JOIN "book" b ON b.owner_id = "user".id GROUP BY "user".id ) as "u0" where "u0"."age" >= 1 order by "u0"."id" asc limit 4 

actual:

select * from ( SELECT "user".id, "user".name, "user".age, COUNT(b.id) AS book_count FROM "user" LEFT JOIN "book" b ON b.owner_id = "user".id GROUP BY "user".id ) as "u0" where "u0"."age" >= 1 order by "u0"."id" asc

What driver are you using?

@mikro-orm/postgresql

MikroORM version

6.3.5-dev.9

Node.js version

20

Operating system

linux

Validations

• Read the Contributing Guidelines.
• Read the docs.
• Check that there isn't already an issue that reports the same bug to avoid creating a duplicate.
• Check that this is a concrete bug. For Q&A open a GitHub Discussion or join our Discord.
• The provided reproduction is a minimal reproducible example of the bug.