I don't think it worth adding C code for external SQL query needs. IIRC, during early SER times there was a command to execute any sql query via mi/fifo, but wasn't feasible and easy to maintain, therefore removed.

I kamctl can be added using db cli application (e.g., mysql) with a bit of grep/sed/awk will print only the value.

Fetching the value via xmlrpc should be possible via a bit of config scripting, inside route[XMLRPC] intercept the command before dispatch_rpc() (search over the body or using xmlops), do appropriate sql_query(...) via sqlops and push back a reply with a body in xmlrpc format.

I would propose to close this item here.

—
Reply to this email directly or view it on GitHub.