I want to write and sql query interceptor and possibly manipulate query results too. I found some documentation for mysql-proxy at http://download.nust.na/pub6/mysql/tech-resources/articles/proxy-gettingstarted.html. this gives me flexibility to manipulate query results using lua. However mysql-proxy is deprecated and recommends to use mysql-router. but the problem is mysql-router does not have support for lua language or any other plugin mechanism to customize the query results.
Tried using mysql-proxy however the tool is deprecated and recommendation is mysql-router