Raw queries should allow scanning row by row

[john8329]

Hi, for performance reasons (and coherence with the standard sql query), when doing db.NewRaw(query) the returned object should have the .Rows() property for using an iterator instead of scanning the whole result.
This is crucial for big workloads where batching is required to avoid using too much memory (exporting for example). Right now the only workaround I can think of is manually adding offset and limit.

Thanks

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.

[john8329]

well, bump. This is a pretty important hole in the features.

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.

[john8329]

Bump again.

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.

[john8329]

Bump. What's the point of this bot?

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.

[john8329]

sigh