Yes. Have you tried using SQL comments in your queries?
With SQL comments you can include comments that are not executed on the database server or alter the way your queries execute. Your DBA should see the query with comments. Then the next time he sends you a query you can identify if it is something you need to look into. That is if the DBA doesn't copy the query without the comments. ;-) If you communicate and test it with your DBA, I am sure he will recognize the value in receiving a faster response.
Here is a couple examples in a QIE mapping function:
Single Line Comment Example:
var pQuery = qie.getParameterizedQuery("-- Set last name with reverse phone number lookup in Test Sql Comments channel, \n" +
"SELECT Last FROM PatientProfile WHERE Phone1 = '5036462755' -- Comment at the end of a line");
var queryResult = pQuery.doQuery(
"MyDatabaseConnection",
false,
false
);
message.setNode("PID-5.1", queryResult.getNode("Last"));
Multi Line Comment Example:
var pQuery = qie.getParameterizedQuery("/* \n" +
" Set last name with reverse phone number lookup\n" +
" Test Sql Comments channel, \n" +
" Test Multi Line Comment function\n" +
"*/\n" +
"SELECT Last /* comment inline */ FROM PatientProfile WHERE Phone1 = '5036497551' /* comment at the end of a line*/");
var queryResult = pQuery.doQuery(
"MyDatabaseConnection",
false,
false
);
message.setNode("PID-5.1", queryResult.getNode("Last"));
See also:
What is the most common SQL comment syntax?