Idea: Group query params

[LeoCaprile]

Hey guys

Introduction

I came across the idea of the posibility to group params in separated structs, to facilitate separation of concern in complex queries or just to organize parameters.

Why

I got the idea wanting to separate the params from the WHERE clause from the SET clause params. see example.

How

My idea of implementation is to create a new sqlc function that takes two parameters:

• The name of the group
• The name of the column to group

Here's an example of the function signature:
sqlc.group('SearchParams', 'id')

Example

Here's an example of a simple use case for the new feature from the sqlc query to the generated code.

Query

-- name: UpdateProduct :many
UPDATE products
SET name=$1 description=$2, price=$3, updated_at=NOW()
WHERE id=sqlc.group("SearchParams", 'id')
RETURNING *;

Generated code

type UpdateProductParams struct {
	Name        pgtype.Text `json:"name"`
	Description pgtype.Text `json:"description"`
	Price       pgtype.Int8 `json:"price"`
}
type SearchParams struct {
	ID          uuid.UUID   `json:"id"`
}

func (q *Queries) UpdateProduct(ctx context.Context, arg UpdateProductParams, arg2 SearchParams) ([]Product, error) {
	rows, err := q.db.Query(ctx, updateProduct,
		arg2.ID, // <-- this argument is passed by arg2 a separated struct
		arg.Name,
		arg.Description,
		arg.Price,
	)
	//... extra generate go code not relevant
}

I could make a PR with the changes if you guys think it's a good idea.
Thanks for reading!