Order by struct field name?

[lukescott]

Looking for a way to order by a struct field name rather than the DB column name.

Something like this:

type SomeParams struct {
	SortField string `json:"sortField"`
	SortDesc  bool   `json:"sortDesc"`
}

type SomeView struct {
	SomeValue string `json:"someValue" pagination:"sortable"`
	// ... some other fields, some sortable, some not
}

type SomeModel struct {
	gorm.Model
	SomeValue string
	// other fields...
	// Field names and types match from SomeModel to SomeView
}

ffunc sudoCodeExample(db *gorm.DB) {
	// comes from api
	params := SomeParams{
		SortField: "someValue",
		SortDesc:  true,
	}

	// getSortable uses reflection to return field.Name and JSON Name specified in Tag
	sortable := getSortable(SomeView{}) // -> [{Name: "SomeValue", JSONName: "someValue"}, ...]

	// findSortableName iterates over sortable slice and returns field name
	fieldName, ok := findSortableName(sortable, "someValue") // -> "SomeValue", true

	var records []SomeModel

	// Note: clause.OrderByField doesn't currently exist (concept)
	db.Order(clause.OrderByField{
		Name: fieldName,
		Desc: params.SortDesc,
	}).Find(&records)

	// or perhaps when joins are used:

	db.Order(clause.OrderByField{
		Model: SomeModel{},
		Name:  fieldName,
		Desc:  params.SortDesc,
	}).Find(&records)
}

Is something like this possible?

My goal is to map the JSON view name to the database column name. The view field name generally matches the model field name. I have an existing function that gets the struct field name from a JSON name.

The use-case is I want to specify which fields in the view are sortable. I have search endpoints that allow users to sort the results. I do not want to expose the table column names and have the view names used instead.