@AlSweigart We put a ton of data into dict & pandas data frames both because we like the API they provide & don't think twice about ACID. So if SQL is a better interface for the problem, the lack of ACID is irrelevant. dotnet world has/had a similar class DataSet which also was a mini-in memory database.
https://learn.microsoft.com/en-us/dotnet/api/system.data.dataset?view=net-7.0