def type_hint2schema_type(type_hint: str):
    """
    Map a Python type hint to an SQLite schema type.

    str -> VARCHAR(200)
    int -> INTEGER
    bool -> BOOLEAN

    """

    if type_hint == 'str':
        return 'VARCHAR'
    elif type_hint == 'int':
        return 'INTEGER'
    elif type_hint == 'bool':
        return 'BOOLEAN'
    else:
        raise ValueError(f'Invalid type "{type_hint}"')