GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — add :stream keyword` · Issue #4464 · sqlc-dev/sqlc

add :stream keyword` #4464

New issue
Copy link
New issue
Copy link
Open
Open
add :stream keyword`#4464
Copy link
Labels
enhancementNew feature or requestNew feature or request

Description

@borissmidt
borissmidt
opened on Jun 1, 2026
Issue body actions

What do you want to change?

Earlier 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.

So 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.

Related issue in the python generator:
sqlc-dev/sqlc-gen-python#101

Previous issues:
#4108
#720

What database engines need to be changed?

PostgreSQL, SQLite, MySQL

What programming language backends need to be changed?

Go, Python, Kotlin

Activity

  1. borissmidt
    added
    enhancementNew feature or requestNew feature or request
    on Jun 1, 2026
  2. borissmidt commented on Jun 1, 2026

    @borissmidt
    borissmidt
    on Jun 1, 2026
    Author
    More actions

    I don't mind picking up the python generator changes needed for this.

  3. Jille commented on Oct 17, 2026

    @Jille
    Jille
    on Oct 17, 2026
    Contributor
    More actions

    See #4647 :)

  4. borissmidt commented on Oct 19, 2026

    @borissmidt
    borissmidt
    on Oct 19, 2026
    Author
    More actions

    4. See #4647 :)

    Yes this is what i need thank you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requestNew feature or request

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      You are visitor 01402503 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.