docs: public void remove(int profileId, String clientUUID) throws Exception {
          PreparedStatement statement = null;
          ResultSet results = null;
          try (Connection sqlConnection = sqlService.getConnection()) {
              // first try selecting the row we want to deal with
              statement = sqlConnection.prepareStatement(
                  "SELECT * FROM " + Constants.DB_TABLE_CLIENT +
                      " WHERE " + Constants.GENERIC_CLIENT_UUID + " = ?" +
                      " AND " + Constants.CLIENT_PROFILE_ID + "= ?"
              );
              statement.setString(1, clientUUID);
              statement.setInt(2, profileId);
              results = statement.executeQuery();
              if (!results.next()) {
                  throw new Exception("Could not find specified clientUUID: " + clientUUID);
              }
          } catch (Exception e) {
              throw e;
          } finally {
              try {
                  if (results != null) {
                      results.close();
                  }
              } catch (Exception e) {
              }
              try {
                  if (statement != null) {
                      statement.close();
                  }
              } catch (Exception e) {
              }
          }
  
          // delete from the client table
          String queryString = "DELETE FROM " + Constants.DB_TABLE_CLIENT +
              " WHERE " + Constants.CLIENT_CLIENT_UUID + " = ? " +
              " AND " + Constants.CLIENT_PROFILE_ID + " = ?";
  
          try (Connection sqlConnection = sqlService.getConnection()) {
              statement = sqlConnection.prepareStatement(queryString);
              statement.setString(1, clientUUID);
              statement.setInt(2, profileId);
  
              logger.info("Query: {}", statement.toString());
              statement.executeUpdate();
          } catch (Exception e) {
              throw e;
          } finally {
              try {
                  if (statement != null) {
                      statement.close();
                  }
              } catch (Exception e) {
              }
          }
  
          // delete from other tables as appropriate
          // need to delete from enabled_overrides and request_response
          try (Connection sqlConnection = sqlService.getConnection()) {
              statement = sqlConnection.prepareStatement(
                  "DELETE FROM " + Constants.DB_TABLE_REQUEST_RESPONSE +
                      " WHERE " + Constants.CLIENT_CLIENT_UUID + " = ? " +
                      " AND " + Constants.CLIENT_PROFILE_ID + " = ?"
              );
              statement.setString(1, clientUUID);
              statement.setInt(2, profileId);
              statement.executeUpdate();
          } catch (Exception e) {
              // ok to swallow this.. just means there wasn't any
          }
  
          try (Connection sqlConnection = sqlService.getConnection()) {
              statement = sqlConnection.prepareStatement(
                  "DELETE FROM " + Constants.DB_TABLE_ENABLED_OVERRIDE +
                      " WHERE " + Constants.CLIENT_CLIENT_UUID + " = ? " +
                      " AND " + Constants.CLIENT_PROFILE_ID + " = ?"
              );
              statement.setString(1, clientUUID);
              statement.setInt(2, profileId);
              statement.executeUpdate();
          } catch (Exception e) {
              // ok to swallow this.. just means there wasn't any
          } finally {
              try {
                  if (statement != null) {
                      statement.close();
                  }
              } catch (Exception e) {
              }
          }
      }