Changes in version 2.5.0 (2026-03-08) - Add Delphi-100k example dataset - Improvements to cdmFromCohortSet/cdmFromJson synthetic data generation - Add cohdSimilarConcepts function to query Columbia Open Health Data API for concept co-occurrence - Add generateCohortSet2 for DAG-based cohort generation without Java dependency - Add R-native CIRCE SQL builder (buildCohortQuery, buildBatchCohortQuery) - Add DAG-based query optimizer and caching - Add batch optimization and benchmarking vignettes - Fix Snowflake column quoting for domain-filtered tables - Fix SQL Server LIMIT syntax error in cdmFromCon when using DatabaseConnector Changes in version 2.4.0 (2026-02-16) - Implement generateCohortSet for local cdms (e.g. with omock) - Allow catalogs in duckdb connections @lyoganathan - Add cdmFromCohortSet to create synthetic cdms from Atlas cohort definitions - Add cdmCommentContents for creating comments with the contents of a CDM in tests and documentation - Make writeSchema optional in cdmFromCon @SulevR Changes in version 2.3.0 (2026-01-10) - Add empty CDM v5.4 example dataset @ginberg - Support integer64 type for personId argument in cdmSubset @elinrow - Support local CDM objects in generateConceptCohortSet and date functions @catalamarti - Fix bug with cohortCodelist creation for some cohorts @sulevR - Simplify cohortCollapse logic and support local cdm tables @ablack3 Changes in version 2.2.0 (2025-09-16) - Test using DatabaseConnector version 7 JDBC connections on all supported databases @IoannaNika - Change summariseQuantile2 output columns to match DrugExposureDiagnostics (e.g. q05, q10) - Add computeDataHash argument to snapshot() - Add computeDataHashByTable function to compute a hash for each CDM table - Update connection examples documentation - Change Eunomia dataset download link - Add Synthea27NjParquet example dataset Changes in version 2.1.1 (2025-07-10) - fix bug with cohort generation @catalamarti - fix bug in summariseQuantile2 @ablack3 Changes in version 2.1.0 (2025-06-25) - Add support for Redshift and Spark with DatabaseConnector driver (pending version 7) @IoannaNika - Update readme instructions to use camel case functions @ginberg - New summariseQuantile2 function that supports multiple variables @ablack3 - Fixed the returned table references @mvankessel-EMC - Validate the writePrefix @xihang-chen Changes in version 2.0.0 (2025-02-21) - Remove snake case functions in favor of only camel case style - Remove cohort table manipulation functions - Add row to cohort attrition table that accounts for record collapsing cohort eras step in Atlas/Circe cohort generation - Increase test coverage - Fix bugs with cdmFlatten - Add support for snowflake with DatabaseConnector driver - Add attrition record for cohort era collapse when generating Atlas cohorts Changes in version 1.7.0 (2024-12-19) - Add support for Big Query using bigrquery DBI package (pending PRs on omopgenerics and bigrquery) @IoannaNika - Add support for the DatabaseConnector postgresql JDBC driver @ablack3 - By default automatically detect CDM version @catalamarti - Deprecate snake case functions @IoannaNika - Deprecate cohort manipulation functions @ablack3 - Deprecate validation functions @ablack3 Changes in version 1.6.1 (2024-11-29) - use BIGINT for subject_id column of cohort tables Changes in version 1.6.0 (2024-11-13) - fix bug in copyCdmTo where attribute tables were not being copied #231 @catalamarti - check that overwrite argument works in compute when using temp tables #222 @ablack3 - added synpuf1k with Achilles tables to example datasets #230 @ablack3 - add requireEunomia function #481 @catalamarti Changes in version 1.5.0 (2024-07-16) - Get all tests passing on Databricks/Spark using odbc driver - Emulate temporary tables on Databricks/Spark when compute is called with temporary = TRUE - soft deprecate asDate in favor of as.Date - soft deprecate assertWriteSchema since cdm object are now required to always have a write schema - remove support for Capr cohort objects in generate_cohort_set to pass CRAN checks Changes in version 1.4.0 (2024-05-03) - fix issue on cran server - new omopgenerics methods Changes in version 1.3.1 (2024-04-02) - Bug fix for collapse cohort - dbplyr 2.5.0 fixes Changes in version 1.3.0 (2024-02-05) - Incorporate omopgenerics Changes in version 1.2.1 (2024-01-18) - Fix failing CRAN tests Changes in version 1.2.0 (2023-10-31) - Compatibility with dbplyr v2.4.0 Changes in version 1.1.4 (2023-10-20) - Fix recursive edge cases with cdm reference issue. Changes in version 1.1.3 (2023-10-14) - Fix recursive cdm reference issue. Thanks @catalamarti! Changes in version 1.1.2 (2023-08-22) - fix failing test on CRAN Changes in version 1.1.1 (2023-08-22) - add some bigquery support August 22, 2023 Changes in version 1.1.0 (2023-08-17) - add copy_cdm_to, copyCdmTo - add generate_concept_cohort_set, generateConceptCohortSet - add more example CDM datasets - add record_cohort_attrition, recordCohortAttrition - improve database test coverage - update vignettes Released Aug 17, 2023 Changes in version 1.0.0 (2023-06-12) - remove write_prefix in cdm_from_con in favor of using the write_schema argument for prefixing - remove cdm_tables argument from cdm_from_con in favor of cdm_select_tbl selection function - add attributes to the cdm object to communicate downstream temp table preferences Released June 7, 2023 Changes in version 0.6.0 (2023-05-05) - generate Capr cohorts with generateCohortSet - add datepart function for extracting year, month, day parts of dates in dplyr - fix datediff logic for years so it now returns number of complete years between two date - add "write_prefix" attribute to cdm objects to support a namespace within the write_schema Released May 5, 2023 Changes in version 0.5.1 (2023-03-22) - Add both camelCase and snake_case versions of all functions (@Tsemharb) - Add cdm object attributes to cdm_snapshot output - use number_records and number_subjects in cohort counts table - Minor bug fixes Released on March 20, 2023 Changes in version 0.5.0 (2023-03-09) - Define generatedCohortSet class - Add summarize_quantile for cross database quantile queries - Add GeneratedCohortSet object, constructor, and attribute accessor functions - Add vignette on cohort generation - Add cdmSubset, cdmSubsetCohort, cdmSample for subsetting a cdm - Add cdmFlatten for transforming a cdm into a single flat table of observations - Improve test coverage - Make Java dependency optional - cdm_schema is now required in cdm_from_con except for duckdb connections - Remove visit_detail from default cdm tables - Deprecate computePermanent - Improve package website Substantial contributions by @edward-burn, @catalamarti, @Tsemharb who are now package co-authors. Released Mar 8, 2023 Changes in version 0.4.1 (2023-01-24) - Add computeQuery function for creating temp and persistent tables from dplyr queries - Download Eunomia from darwin-eu repository as zipped csv files - Add passing tests for Oracle and Spark - Add asDate wrapper that provides correct as.Date dbplyr translations - Incorporate code review suggestions from @mvankessel-EMC Released Jan 21, 2023 Changes in version 0.3.0 (2022-11-29) - Add computePermanent and appendPermanent functions - Add readCohortSet - Add generateCohortSet - Extract Eunomia dataset so that it is downloaded separately Released Nov 29, 2022 Changes in version 0.2.0 - Add support for OMOP v5.3 and v5.4 - Add datediff and dateadd functions that can be used in dplyr::mutate() - Add assert_tables function for checking that a cdm object has required tables - Add camelCase versions of several functions Released Nov 15, 2022 Changes in version 0.1.0 (2022-09-29) - Initial release Sept 11, 2022 - Added a NEWS.md file to track changes to the package.