Wrong base table - Column not found: 1054 Unknown column 'field_data_XXX.nid' ...

I'm coming from issue #2087849 (for the view_unpublished) module. I have read #1413108: entityFieldQueryAlter() should check if correct table exists which unfortunately doesn't solve my problem. However, the route cause is the same: The field table is used, not the node table, and hence a column (nid in this case) is missing.

There is a similar bug report - #1935552: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column - so maybe this report could be considered a duplicate, but it's easier to reproduce this bug ...

Steps to reproduce:
1) Install the view_unpublished module or any other module that implements node grants. (I'm using a totally stripped down version of view_unpublished, which I have called entityreference_test. I'll be happy to attach it.)
2) Create two content types A and B, and add an entityreference field on content type A.
3) Configure the entityreference widget to have B as "Target bundles" and to sort on "A field attached to this entity".
4) Go to example.org/?q=node/add/a (as a user without "bypass node access" permission) and by greeted with the following error:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_ipaddress0.nid' in 'where clause': SELECT DISTINCT field_data_field_ipaddress0.entity_type AS entity_type, field_data_field_ipaddress0.entity_id AS entity_id, field_data_field_ipaddress0.revision_id AS revision_id, field_data_field_ipaddress0.bundle AS bundle
FROM 
{field_data_field_ipaddress} field_data_field_ipaddress0
WHERE  (field_data_field_ipaddress0.deleted = :db_condition_placeholder_0) AND (field_data_field_ipaddress0.entity_type = :db_condition_placeholder_1) AND (field_data_field_ipaddress0.bundle IN  (:db_condition_placeholder_2)) AND(( ( EXISTS  (SELECT na.nid AS nid
FROM 
{node_access} na
WHERE (( (na.gid = :db_condition_placeholder_3) AND (na.realm = :db_condition_placeholder_4) )OR( (na.gid = :db_condition_placeholder_5) AND (na.realm = :db_condition_placeholder_6) ))AND (na.grant_view >= :db_condition_placeholder_7) AND (field_data_field_ipaddress0.entity_id = na.nid) )) AND (field_data_field_ipaddress0.entity_type = :db_condition_placeholder_8) )OR (field_data_field_ipaddress0.entity_type <> :db_condition_placeholder_9) )AND ( EXISTS  (SELECT na.nid AS nid
FROM 
{node_access} na
WHERE (( (na.gid = :db_condition_placeholder_10) AND (na.realm = :db_condition_placeholder_11) )OR( (na.gid = :db_condition_placeholder_12) AND (na.realm = :db_condition_placeholder_13) ))AND (na.grant_view >= :db_condition_placeholder_14) AND (field_data_field_ipaddress0.nid = na.nid) )) 
ORDER BY field_data_field_ipaddress0.field_ipaddress_start ASC; Array
(
    [:db_condition_placeholder_0] => 0
    [:db_condition_placeholder_1] => node
    [:db_condition_placeholder_2] => article
    [:db_condition_placeholder_3] => 0
    [:db_condition_placeholder_4] => all
    [:db_condition_placeholder_5] => 1
    [:db_condition_placeholder_6] => view_unpublished_content
    [:db_condition_placeholder_7] => 1
    [:db_condition_placeholder_8] => node
    [:db_condition_placeholder_9] => node
    [:db_condition_placeholder_10] => 0
    [:db_condition_placeholder_11] => all
    [:db_condition_placeholder_12] => 1
    [:db_condition_placeholder_13] => view_unpublished_content
    [:db_condition_placeholder_14] => 1
)
 in field_sql_storage_field_storage_query() (line 585 of ../modules/field/modules/field_sql_storage/field_sql_storage.module).

Notice how we have on correct comparison "field_data_field_ipaddress0.entity_id = na.nid" and on wrong "field_data_field_ipaddress0.nid = na.nid".

5) If you change to sort on "A property of the base table of the entity" the problem is gone since the base table no longer isn't the field table.

PS! Could this be a core bug in the node_access function:

$nids = db_or()->condition('nid', $node->nid);