Support dynamic order by clause #2061
Description
the order by clause in the :many definition query should be set dynamically
-- name: ListOrders :many select * from order where status = $1 order by @orderBy::text; Generated
const listOrders = "select * from order where status = $1 order by @orderBy::text"
type ListOrdersParams struct { Status string OrderBy string } func (q *Queries) ListOrders(ctx context.Context, arg ListOrdersParams) ([]*ListOrdersRow, error) { orderBy:=arg.OrderBy if orderBy=="" { orderBy= "0" } listOrdersWithOrderBy = strings.Replace(listOrders, "@orderBy::text", orderBy, -1) rows, err := q.db.Query(ctx, listOrdersWithOrderBy, arg.Status) ... What database engines need to be changed?
PostgreSQL, MySQL
What programming language backends need to be changed?
Go, Python, Kotlin