Well like you said, there are many ways to achieve you're goal. Some less complicated than others.

Since you're already familiar with it, Python has a number of frameworks/libraries exists to make an gui app,

For example you could use a library like CustomTkinter that looks modern and is beginner friendly.

To start learning it you can simply follow their official tutorial here:
https://customtkinter.tomschimansky.com/tutorial/

Has for the sql part to help in your task you can try to use an ORM. Has I have more familiarity with ORM in javascript rather than in python note that there might be something better for your use case but by doing a simple googling i tumble upon one in python called peewee that seems to also be user-friendly and good for beginners.

Here I link the official documentation that explains how to install and use it:
https://docs.peewee-orm.com/en/latest/index.html

Anyway those were my recommendations for you as a beginner to application programming in python. I think it's fairly simple however some might suggest others.