Use a struct for named args

[mxey]

Is your feature request related to a problem? Please describe.

When querying data with pgx, I can quite easily load the data into structs using the various RowTo functions.
However, when inserting data, I have to repeat field names a lot:

_, err := c.db.Exec(ctx, `
	INSERT INTO foo (col)
	VALUES (@col)
`, pgx.StrictNamedArgs{
	"col":                 m.Col,
})

Describe the solution you'd like

A feature similar to (Strict)NamedArgs, but instead of passing a map, passing a struct with the appropriate struct tags:

type Foo struct {
	Col string `db:"col"`
}

_, err := c.db.Exec(ctx, `
	INSERT INTO foo (col)
	VALUES (@col)
`, pgx.StructArgs(m))

Describe alternatives you've considered

None.

Additional context

None.

[jackc]

That's definitely doable. In your example, pgx.StructArgs(m) would return a pgx.QueryRewriter that reflected over the struct fields.

[mxey]

In your example, pgx.StructArgs(m) would return a pgx.QueryRewriter that reflected over the struct fields.

Yeah I took a quick look at the implementation of NamedArgs when I saw the QueryRewriter interface, but AFAICT I'd have to reimplement the SQL parsing logic, because that's not exposed.

[jackc]

The function could return a pgx.NamedArgs.

[Tubelight30]

I’m planning to implement a helper similar to NamedArgs that accepts a struct with db tags for named‑arg queries, and I’ll open a PR once it’s ready. Is this still a welcome addition to the library?

[Tubelight30]

Hey @jackc and @mxey,
Hey, I’ve opened a PR for this and worked on StructArgs / StrictStructArgs. Let me know if that approach matches the intended direction.