Insert Update

###Insert and Update queries####

query.update(sqlQuery)...

Creates an insert or update query that can be parameterized executed. ####Parameters#### Both positional and named parameters are supported

UpdateResult result = query
	.update("UPDATE CUSTOMER SET NAME = ?, ADDRESS = ?")
	.params("John Doe", "Dallas")
	.run();

Map<String, Object> namedParams = new HashMap<>();
namedParams.put("name", "John Doe");
namedParams.put("address", "Dallas");

UpdateResult result = query
	.update("UPDATE CUSTOMER SET NAME = :name, ADDRESS = :address")
	.namedParams(namedParams)
	.run();

####Update result#### UpdateResult contains stats about a successfully executed query. Note: errors trigger exceptions

UpdateResult result = query ...
Long affectedRows = result.affectedRows();