I want when the user clicks on a button on the browser
“Perform monthly billing run” the controller to lanch a sql DML
statment to be called (in the model?) than runs something like
“insert into billing (item, qnt, total_cost, billing_run_timestamp
select item, qnt, item*cost as total_cost, timestamp
where service_end_date is null”
How can I run a DML (insert, update, delete) direct sql statement ?