Sails common API function

functionname.js

// you can refer https://sailsjs.com/documentation/reference/waterline-orm/datastores/send-native-query
// Build our SQL query template.
var SPNAME_CALL_SQL = `call sp_spname($1,$2)`;

// Send it to the database.
var rawResult = await sails.sendNativeQuery(SPNAME_CALL_SQL, [ 'dog', 'cat' ]);
 
return exits.success();