RMM is an R package designed to handle common ohdsi results data management functions by providing a common API for data model migrations and definitions
DDL csvs should be standardized in this package and allow a class that loads them, checks them and exposes basic queries automatically.
Could, from a csv that specifies data types, be automatically created in all database engines and checked for changes/compatibility against some existing data model.
Additionally, it would be fairly straightforward to create data model classes from these specifications that could provide simple getters to query the db via the fields included.
If foreign keys are exposed in the ddl relationships between tables could also be captured automatically.
DDL csvs should be standardized in this package and allow a class that loads them, checks them and exposes basic queries automatically.
Could, from a csv that specifies data types, be automatically created in all database engines and checked for changes/compatibility against some existing data model.
Additionally, it would be fairly straightforward to create data model classes from these specifications that could provide simple getters to query the db via the fields included.
If foreign keys are exposed in the ddl relationships between tables could also be captured automatically.