Maybe VisiData is up your alley? It doesn't do foreign key enforcement (yet) and is more for exploring than modifying, but with the new vdsql functionality I c

Maybe VisiData is up your alley? It doesn't do foreign key enforcement (yet) and is more for exploring than modifying, but with the new vdsql functionality I could see it being some part of what you want. Disclaimer: am author.