Is it possible to make a python application where the user will enter a request (select, etc. ), which will be directed to an existing database?

Question

Python

There is some kind of database.
I want to know if it is possible to write an application in python, where the user in the window will write a query (select, insert, delete) to the database server. (The result of the request is sent to the user on the screen)
I also want to provide for the commit and rollback of the entered requests + creating a backup copy of the database data in the form of an sql file, that is, there will be some function that will create an sql script, the execution of which will restore the data that was in the database at the time this script was created.
where to look? what can you suggest? for gui , I think you can take tkinter?
I am especially interested in the moment responsible for how the entered query will contact the database server and be executed ..

Answer 1

You want to write a GUI wrapper for a database library.
Well, in general, the matter is small - choose a GUI (I personally recommend pyqt), choose a database (I personally recommend postgresql), choose a connector library for the database (for postgresql, this is most often psycopg2) and ... write all the application logic.

Answer 2

You know Tkinter, but there are no connectors to the database?