I would also like to see some resolution to this. We have large data sets in our application and I would like to fetch collections for many parents lazily with subselect fetching. However, we run in to the 2000 limit on SQL if I try today. I understand if this cannot be solved 100% in the framework, but I would at least like a point in the API (Dialect, etc.) where I can customize the IN clause generated / prepared statement binding for collection fetching for our particular use case.
I would also like to see some resolution to this. We have large data sets in our application and I would like to fetch collections for many parents lazily with subselect fetching. However, we run in to the 2000 limit on SQL if I try today. I understand if this cannot be solved 100% in the framework, but I would at least like a point in the API (Dialect, etc.) where I can customize the IN clause generated / prepared statement binding for collection fetching for our particular use case.