func:sqlInsert

sqlInsert(data, conn, table)

Insert a record or grid of records into the given table. If data is a dict, thena single row is inserted. If data is a grid or list of dicts, then each row is inserted. The data's column names must match the table's columns. If the data has a tag/column not found in the table then it is ignored.

WARNING: any admin user will have full access to update the database based on the user account configured by the sqlConn.