SELECT JOIN - tortoise-orm

models.py

from tortoise import fields, Model


class Person(Model):
    id = fields.IntField(pk=True)
    name = fields.TextField()

    def __str__(self):
        return self.name


class Pet(Model):
    id = fields.CharField(30, pk=True)  # Can be an IntField too
    name = fields.TextField()
    # related_name is the name af attribute that we will use to accet Pet in the Person model
    owner = fields.ForeignKeyField('models.Person', related_name='pet')

    def __str__(self):
        return self.name

query.py

from models import Person, Pet


async def queries():
    # Populating the database
    person = await Person.create(name='Kuba')
    pet = await Pet.create(id='pet_id', name='Kora', owner=person)
    
    # Executing a select query with a JOIN
    query = Person.get(name='Kuba')
    person = await query.select_related('pet')
    # print(query.sql())  # uncomment to see the query
    print(f'{person} has a pet named {person.pet}')