Add hook to support advanced SQL#598

By adding this hook, I am able to support CTEs in a SQL query.

The attached patch adds a filter named “wpdatatables_handle_special_query”.

I could provide the code that supports CTEs too if you want it.

Hi Paul,

Thank you for your time and for sharing this information. We will forward the data to our development team so they can test it and consider adding it to the code. Also, if you have any additional details or examples, we would be grateful—both for us and for other users—so we can include them in the documentation.