public List<FriendRequest> getAllFriendRequestsForUser(String username) throws SQLException {
    Connection databaseConnection = database.getConnection();
    Statement statement = databaseConnection.createStatement();
    String query = String.format(GET_ALL_REQUEST_FOR_USER, username);
    ResultSet results = statement.executeQuery(query);
    ArrayList<FriendRequest> friendRequest = new ArrayList<>();
    String fromUsername, fromName;
    while (results.next()) {
      fromUsername = results.getString(1);
      fromName = results.getString(2);
      friendRequest.add(new FriendRequest(fromUsername, fromName, username));
    }
    return friendRequest;
  }