def METHOD_NAME(self):
    """
    An assortment of queries to make sure that tables with a custom primary
    key column defined work as expected.
    """
    Manager.insert(
        Manager(name="Guido"),
        Manager(name="Graydon"),
    ).run_sync()
    #######################################################################
    # Make sure they've been saved in the database, and the return types
    # are correct
    self.assertTrue(
        Manager.select(Manager.name)
        .output(as_list=True)
        .order_by(Manager.name)
        .run_sync(),
        ["Guido", "Graydon"],
    )
    manager_dict = Manager.select().first().run_sync()
    self.assertEqual(
        [i for i in manager_dict.keys()],
        ["pk", "name"],
    )
    self.assertIsInstance(manager_dict["pk"], uuid.UUID)
    #######################################################################
    # Make sure we can create rows with foreign keys to tables with a
    # custom primary key column.
    manager = Manager.objects().first().run_sync()
    band = Band(manager=manager, name="Pythonistas")
    band.save().run_sync()
    band_dict = Band.select().first().run_sync()
    self.assertEqual(
        [i for i in band_dict.keys()], ["pk", "name", "manager"]
    )
    self.assertIsInstance(band_dict["pk"], uuid.UUID)
    self.assertIsInstance(band_dict["manager"], uuid.UUID)
    #######################################################################
    # Make sure foreign key values can be specified as the primary key's
    # type (i.e. `uuid.UUID`).
    manager = Manager.objects().first().run_sync()
    band_2 = Band(manager=manager.pk, name="Pythonistas 2")
    band_2.save().run_sync()
    self.assertEqual(
        Band.select(Band.name)
        .output(as_list=True)
        .order_by(Band.name)
        .run_sync(),
        ["Pythonistas", "Pythonistas 2"],
    )
    #######################################################################
    # Make sure `get_related` works
    self.assertEqual(
        band_2.get_related(Band.manager).run_sync().pk, manager.pk
    )
    #######################################################################
    # Make sure `remove` works
    band_2.remove().run_sync()
    self.assertEqual(
        Band.select(Band.name)
        .output(as_list=True)
        .order_by(Band.name)
        .run_sync(),
        ["Pythonistas"],
    )