@david.wylie is correct: Anvil’s Data Tables is a database specially constructed to be easy to use from Python. The nice API (app_tables.<name>) and the visual table editor need that back-end to function.
If you want to work with any arbitrary external database, of course you can do that, with all the standard Python libraries – you’ve got the whole Python ecosystem! But if you want to use Data Tables, use Data Tables 