Query Loop - Order Terms by term_order

How To
1

I have a column in my terms table called term_order that was added by a plugin. I want to use this column as the sort order when querying terms via query loop.

This does not work:

return [
  'taxonomy'      => 'category',
  'number'        => 100,
  'orderby'       => 'term_order',
  'order'         => 'ASC',
  'hide_empty'    => true,
  'exclude'       => [1],
  'parent'        => get_queried_object_id(),
];

becauseā€¦

Using 'orderby' => 'term_order' directly within a get_terms or WP_Term_Query call in the manner youā€™ve outlined presupposes that the term query system recognizes term_order as a valid ordering parameter. In standard WordPress installations, terms do not have an inherent term_order attribute in the database schema for direct ordering, unlike posts which have a menu_order attribute.

Does anyone have a way to do this? To be clear, term_order is not part of the termmeta table, itā€™s a column in the terms table.