For me the issue was that I was running Peewee in wsl and installed the pip package there. So the script would run well when I called this tutorial script through the terminal.
But when i pressed the Run button in vs code it would not work and ask SQlitedatabase not found etc.
So I also installed it in windows with pip install peewee. Now both methods work perfect! Hope this helps someone.