I was very excited about the use case of creating Patient Records with 1:M records nested (such as Diagnosis, Procedures etc). We have done this in MongoDB and could use a SQL driver to get the nested “rows”. I understand that the idea of nested “rows” ate actually columns with “column_name:id” for each “row value”. Seems a bit odd compare to a document / JSON layout, but okay. However, how does one use a SQL driver for reporting and “unnesting” this data?
Is that even possible … I want to “select count(nested_procedures), patient_type from patient group by patient_type)”….. in with Mongo driver it is a virtual table like "select count(patient_procedures \.nested_procedures), patient_type from patient, patient_procedures group by patient_type)” Is this possible?
