json - How to do a SQL like INNER JOIN on multiple Python dictionaries -
i planning out django app allows users not build custom tables associated models (e.g., user create trivial custom "parking spot" table associated "employee" model without having edit models.py), build custom reports using custom tables. way can think having model stores custom table data in jsonfield (i'm using postgres backend works out great), , have reports model allows users build , save "sql-like" queries return joined datasets custom reports. i've figured out how store custom tables , use them in app, , have loose concept on how merge multiple json objects on pseudo foreign keys pulled custom reports, have gotten far creating one-to-one joins. with script below, if of dicts have multiple records on single foreign key last record used. have idea how can accomplish one-to-many join of multiple python dictionaries? if have these 3 datasets: employees = [{"id": 1, "user_id": 303, "name": "mike...