What is required to make this work where civi and drupal are in a single table

Thanks @markusa. I need to access CiviCRM Contacts and Memberships with Views in Drupal 10 and found this issue. I eventually found out that https://www.drupal.org/project/civicrm_entity → is probably the solution.

You could consider adding a short text at the top of the project page for this module?

To access CiviCRM entities with Views and much more in Drupal 10, see CiviCRM Entity →