Function AddOrderBy

pkg/transform/orderby.go:29–41

AddOrderBy returns a Rule that appends an ORDER BY expression to a SELECT statement. Multiple calls append additional sort keys in the order they are applied. Parameters: - column: Name of the column (or expression alias) to sort by - desc: When true the sort direction is DESC; when false it is ASC

(column string, desc bool)

//
// Returns ErrUnsupportedStatement for non-SELECT statements.
func AddOrderBy(column string, desc bool) Rule {
	return RuleFunc(func(stmt ast.Statement) error {
		sel, err := getSelect(stmt, "AddOrderBy")
		if err != nil {
			return err
		}
		sel.OrderBy = append(sel.OrderBy, ast.OrderByExpression{
			Expression: &ast.Identifier{Name: column},
			Ascending:  !desc,
		})
		return nil
	})
}

// RemoveOrderBy returns a Rule that removes the ORDER BY clause entirely from a
// SELECT statement, leaving the result set in an unspecified (engine-dependent)