>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #3411981. --> Reported by: [larowlan](https://www.drupal.org/user/395439) Related to !26 >>> <h3 id="summary-problem-motivation">Problem/Motivation</h3> <p>Rewrite to use common table expressions per <a href="https://github.com/nterbogt/entity_hierarchy/pull/2">https://github.com/nterbogt/entity_hierarchy/pull/2</a></p> <h4 id="summary-steps-reproduce">Steps to reproduce</h4> <h3 id="summary-proposed-resolution">Proposed resolution</h3> <h3 id="summary-remaining-tasks">Remaining tasks</h3> <ol> <li><del>See if we can do something with the views arguments, as they're useful</del></li> <li>hook_requirements to prevent install if no support for CTEs</li> </ol> <h3 id="summary-ui-changes">User interface changes</h3> <h3 id="summary-api-changes">API changes</h3> <h3 id="summary-data-model-changes">Data model changes</h3>