Can someone from IA comment on whether functions such as system.db.runQuery mark the connection as read-only? I am thinking of the javadoc below.
My guess is no, and there are several possible reasons not to do it. The alternative is to define a read-only user in the database and specify that user for the connection credentials.
The general idea is our case is to get some performance optimization in mixed-node environments where read queries can be shared among multiple nodes, but writes must go to only one node.