I want to create a SQL like language using Python. I want it to look like CMD but always open a proper dedicated tab instead of opening Command prompt to take in the commands. Any recommendations for modules that let you create a command line?

I could use Tkinter and take input from user and process it but I'm curious if there's a better way of doing this.