René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"add :stream keyword`","articleBody":"### What do you want to change?\n\nEarlier requests have been made to return an iterator, but we have to be careful not to break the 'RETURNING' statements that don't work well with a cursor. Also the developer kind of knows it is a 'big query' or not. \n\nSo instead of changing existing behavior i would suggest adding a new keyword `:stream` for returning an iterator and using a cursor. Then it is up to the developer himself to decide can i return an iterator or array.\n\nRelated issue in the python generator:\nhttps://github.com/sqlc-dev/sqlc-gen-python/issues/101\n\nPrevious issues:\nhttps://github.com/sqlc-dev/sqlc/issues/4108\nhttps://github.com/sqlc-dev/sqlc/issues/720\n\n### What database engines need to be changed?\n\nPostgreSQL, SQLite, MySQL\n\n### What programming language backends need to be changed?\n\nGo, Python, Kotlin","author":{"url":"https://github.com/borissmidt","@type":"Person","name":"borissmidt"},"datePublished":"2026-06-01T09:58:02.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/4464/sqlc/issues/4464"}