Batch insert query using system.db?

In java you can execute batch query like :

import java.sql.Connection;
import java.sql.PreparedStatement;


String sql = "insert into employee (name, city, phone) values (?, ?, ?)";
Connection connection = new getConnection();
PreparedStatement ps = connection.prepareStatement(sql);

for (Employee employee: employees) {

	ps.setString(1, employee.getName());
	ps.setString(2, employee.getCity());
	ps.setString(3, employee.getPhone());

I don’t find any ignition system script function to achieve such batch command.
I have lots of data to insert in Mysql DB, what is the most effective ignition script command for this ?

There is the pa.db.insertRows function from the Power Scripting module. It takes an Ignition dataset and efficiently inserts all the rows in the dataset into a database table. It is the easiest way in Ignition to efficiently insert many rows of data into a database table.