code: public static Long insert(String poolName, String sql, Object[] params) throws YankSQLException {
  
      Long returnLong = null;
  
      try {
        ResultSetHandler<Long> rsh = new InsertedIDResultSetHandler();
        returnLong =
            new QueryRunner(YANK_POOL_MANAGER.getConnectionPool(poolName)).insert(sql, rsh, params);
      } catch (SQLException e) {
        handleSQLException(e, poolName, sql);
      }
  
      return returnLong == null ? 0 : returnLong;
    }
docs: Executes a given INSERT SQL prepared statement. Returns the auto-increment id of the inserted
  row. Note: This only works when the auto-increment table column is in the first column in the
  table!
  
  @param poolName The name of the connection pool to query against
  @param sql The query to execute
  @param params The replacement parameters
  @return the auto-increment id of the inserted row, or null if no id is available