René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Ability to return an iterator on a \"many\" query","articleBody":"Hi, when a query return a myriad of objects, the slice based solution is not very efficient, it would be great if it was possible to have a way to return some kind of iterator on the rows, something like sql.Rows but type safe.\r\n\r\nThe first solution that comes to mind is to add a new type of function in the sql queries builder.\r\nInstead of writing `-- name: Name :many` we would write `-- name: Name :rows` or another relevant keyword\r\n\r\nand for the generated code, it would look something like this\r\n```sql\r\nCREATE TABLE pilots (\r\n          id integer NOT NULL,\r\n          name text NOT NULL\r\n);\r\n\r\nALTER TABLE pilots ADD CONSTRAINT pilot_pkey PRIMARY KEY (id);\r\n```\r\n```sql\r\n-- name: ListPilots :rows\r\nSELECT * FROM pilots;\r\n```\r\n```go\r\ntype Pilot struct {\r\n\tID   int32\r\n\tName string\r\n}\r\n\r\ntype PilotRows struct {\r\n\trows *sql.Rows\r\n}\r\n\r\nfunc (p *PilotRows) Close() error {\r\n\treturn p.rows.Close()\r\n}\r\nfunc (p *PilotRows) Next() bool {\r\n\treturn p.rows.Next()\r\n}\r\nfunc (p *PilotRows) Scan(dest *Pilot) error {\r\n\treturn p.rows.Scan(dest.ID, dest.Name)\r\n}\r\nfunc (p *PilotRows) Err() error {\r\n\treturn p.rows.Err()\r\n}\r\n\r\nfunc (q *Queries) ListPilots(ctx context.Context) (*PilotRows, error) {\r\n\trows, err := q.query(ctx, q.listPilotsStmtn, listPilots)\r\n\tif err != nil {\r\n\t\treturn nil, err\r\n\t}\r\n\treturn \u0026PilotRows{rows: rows}, nil\r\n}\r\n\r\n```\r\n","author":{"url":"https://github.com/encendre","@type":"Person","name":"encendre"},"datePublished":"2020-09-27T04:11:49.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":22},"url":"https://github.com/720/sqlc/issues/720"}