René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[proposal] `:map key=somefield` query annotation","articleBody":"### What do you want to change?\n\nI frequently find myself converting the results from a query to a map, keyed by one of the fields. The code looks like this:\r\n\r\n```\r\nm := map[string]gendb.User{}\r\nusers, err := gendb.QueryUsers(ctx)\r\nfor _, u := range users {\r\n  m[u.Username] = u\r\n}\r\n```\r\n\r\nI've been holding off on this feature request hoping that generics would cleanly solve this, but solutions with generics aren't as pretty as I'd hoped. (Using a Map plus a lambda to return a field.)\r\n\r\nGiven that sqlc has all the information needed for this, it would be a neat convenience if sqlc could generate this boilerplate for me :)\r\n\r\nI'm willing to send a PR if approved.\n\n### What database engines need to be changed?\n\n_No response_\n\n### What programming language backends need to be changed?\n\nGo","author":{"url":"https://github.com/Jille","@type":"Person","name":"Jille"},"datePublished":"2023-06-21T21:30:05.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/2353/sqlc/issues/2353"}