Error when sorting views by moderation state

Problem/Motivation

When a view allows sorting by current moderation state, it causes an exception.

This may be the same issue as 🐛 Unable to sort by current moderation state. Column not found Needs work , but on that issue there's a suggestion that it is reproducible without views_cm_current_state

Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Content[content]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unknown' in 'order clause': SELECT "node_field_data"."nid" AS "nid", "users_field_data_node_field_data"."uid" AS "users_field_data_node_field_data_uid", "users_field_data_node_field_data_1"."uid" AS "users_field_data_node_field_data_1_uid"
FROM "node_field_data" "node_field_data"
INNER JOIN "users_field_data" "users_field_data_node_field_data" ON node_field_data.uid = users_field_data_node_field_data.uid
LEFT JOIN "users_field_data" "users_field_data_node_field_data_1" ON node_field_data.uid = users_field_data_node_field_data_1.uid
WHERE ((node_field_data.status = 1 OR (node_field_data.uid = 25481 AND 25481  0 AND 0 = 1) OR 0 = 1 OR 1 = 1)) AND ("node_field_data"."type" IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8)) AND ("node_field_data"."type" IN (:db_condition_placeholder_9, :db_condition_placeholder_10, :db_condition_placeholder_11, :db_condition_placeholder_12))
ORDER BY "unknown" ASC
LIMIT 50 OFFSET 0; Array
(
    [:db_condition_placeholder_0] => article
    [:db_condition_placeholder_1] => code
    [:db_condition_placeholder_2] => code_modification
    [:db_condition_placeholder_3] => contact
    [:db_condition_placeholder_4] => document
    [:db_condition_placeholder_5] => event
    [:db_condition_placeholder_6] => event_series
    [:db_condition_placeholder_7] => page
    [:db_condition_placeholder_8] => press_release
    [:db_condition_placeholder_9] => article
    [:db_condition_placeholder_10] => document
    [:db_condition_placeholder_11] => page
    [:db_condition_placeholder_12] => press_release
)
in main() (line 19 of /var/www/html/docroot/index.php)

Steps to reproduce

1. create a table view with the current moderation state as a sortable column
2.

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes