Sorting in the Entity Query

It is a cool thing to do! I ended up following this guide: https://medium.com/@pankajsachdeva_76544/join-tables-using-entityquery-drupal-2599edc9b343

And my hook_query_TAG_alter() hook ended up looking like this:

/**
 * Implements hook_query_TAG_alter().
 */
function mymodule_query_TAG_alter(AlterableInterface $query) {
  $query->addJoin('LEFT', 'draggableviews_structure', 'ds', '[ds].[entity_id] = [base_table].[id]');
  $query->orderBy('ds.weight', 'DESC');
}