I was going to suggest the SQLite source code. One could probably go quite a ways in bare python with lists of dataclasses and pickles, never mind the performa

I was going to suggest the SQLite source code. One could probably go quite a ways in bare python with lists of dataclasses and pickles, never mind the performance. That's your backend. Then you might find some prior art in the way of a SQL parser for a front end.