Is your enhancement related to a problem? Please describe.

This issue is to investigate ElasticPress's compatibility with WooCommerce High-Performance Order Storage.

My findings so far:

• 100% compatibility would be very hard to achieve, as data requests to the new custom table are spread throughout the code base, like here, for example;
• It seems the best candidate for a replacement with a compatibility layer would be the OrdersTableQuery class, as it is responsible for running queries
• The OrdersTableQuery class is called directly by the OrdersTableDataStore class here, so we might need to override that one too.
• Due to the way the WC container works, it won't allow us to simply replace a class, so we might need a new filter to be added.

Code of Conduct

• I agree to follow this project's Code of Conduct