How to set a variable number of arguments for someone else's function?

Question

SQL

Please help, there is a lot of boilerplate code when you execute ExecSQLEx, for example:

if not DataModule1.UniConnection1.InTransaction then 
DataModule1.UniConnection1.StartTransaction;          
try          
  //тут выполняемый запрос
  DataModule1.UniConnection1.ExecSQLEx('UPDATE ...','parametr1', parametr1, 'parametr2', parametr2,'parametr3', parametr3 ...);
  DataModule1.UniConnection1.Commit;  
except on E: Exception do
  begin
    DataModule1.UniConnection1.Rollback;
  end;
end;

I would like to put this in a separate function, where you only need to specify the SQL query text and parameters, but I just can’t figure out how to do it correctly. The problem is that there can be a different number of input parameters, and their types can be different. My idea of ​​how it should look like:

...
class function upd<T> (SQL:string; params: array of T): T; static;
...
 function TForm1.upd<T> (SQL:string; params: array of T): T;
 begin
  if not DataModule1.UniConnection1.InTransaction then
  DataModule1.UniConnection1.StartTransaction;
  try

    DataModule1.UniConnection1.ExecSQLEx(SQL, params[i]) //как здесь перечислить в цикле и указать входящие аргументы?
    DataModule1.UniConnection1.Commit;
  except on E: Exception do
    begin
      DataModule1.UniConnection1.Rollback;
      ShowMessage('Ошибка: '+ E.Message)
    end;
  end;
 end;

How to do it right?

Answer 1

probably something like this:

class function upd<T>(SQL: string; params: array of Variant): Variant; static;
...
function TForm1.upd<T>(SQL: string; params: array of Variant): Variant;
begin
  ...
  DataModule1.UniConnection1.ExecSQLEx(SQL, params); 
  DataModule1.UniConnection1.Commit;
  ...
end;