Execute a query and read the response immediately

[Peter Romianowski]

Hi,

I need to perform a query whenever the proxy starts or at least when a connection is being established and I need the result BEFORE any other query is issued. AFAIK you can inject queries only within read_query. In my scenario I need to first do a SELECT, read its result and THEN I am able to handle all other statements since I need the information from that initial SELECT to decide how to rewrite the following queries.

Would it be possible to enable sending queries within connect_server or (even better) have something like local result = execute_query("SELECT ...") which blocks and returns the result. (Though I guess the latter one is outside the scope of the proxy).

Cheers,

Peter