Swastik

> If you collect you load everything into memory? If the result doesn't fit into memory you will go OOM. Yes but result set is very small with just 28...

> Have you got a repro? Sorry didn't get that. You mean to replicate the issue?

This looks like more specific to os and architecture maybe.. script got killed while performing `iter_rows` operation also. I can't share my data since they are confidential. Give me some...

> Could you please try the last released version [0.1.2](https://central.sonatype.dev/artifact/com.github.gwenn/sqlite-dialect/0.1.2). Or this unreleased patch related to [Identity](https://github.com/gwenn/sqlite-dialect/commit/43fdae9dd5bcf245ed148bf3e4711adf463b5eee): > > > use_get_generated_keys must be set to `false` to activate RETURNING clause...

> And in case you didn't know: https://hibernate.atlassian.net/browse/HHH-10668 So if you use hibernate >= 6, you should use the community dialect instead... We are using hibernate `5.4.25.Final`