Bug: Using derive_vars_query with admiral::ADMH and admiral::queries_mh errors

[bms63]

What happened?

While adopting the data/data-raw convention we were re-running old code and noticed that this code no longer worked

Session Information

R version 4.3.3 (2024-02-29 ucrt)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 19045)

Matrix products: default

locale:
[1] LC_COLLATE=English_United Kingdom.utf8 LC_CTYPE=English_United Kingdom.utf8
[3] LC_MONETARY=English_United Kingdom.utf8 LC_NUMERIC=C
[5] LC_TIME=English_United Kingdom.utf8

time zone: America/New_York
tzcode source: internal

attached base packages:
[1] stats graphics grDevices utils datasets methods base

other attached packages:
[1] stringr_1.5.1 lubridate_1.9.3 dplyr_1.1.4
[4] pharmaversesdtm_1.0.0 admiral_1.1.1

loaded via a namespace (and not attached):
[1] vctrs_0.6.5 cli_3.6.3 rlang_1.1.4 stringi_1.8.4
[5] purrr_1.0.2 generics_0.1.3 assertthat_0.2.1 glue_1.8.0
[9] rprojroot_2.0.4 hms_1.1.3 fansi_1.0.6 admiraldev_1.1.0
[13] tibble_3.2.1 lifecycle_1.0.4 diffdf_1.1.1 compiler_4.3.3
[17] fs_1.6.4 timechange_0.3.0 pkgconfig_2.0.3 tidyr_1.3.1
[21] rstudioapi_0.17.0 R6_2.5.1 tidyselect_1.2.1 utf8_1.2.4
[25] usethis_3.0.0 pillar_1.9.0 magrittr_2.0.3 tools_4.3.3
[29] withr_3.0.1 desc_1.4.3

Reproducible Example

Please see the file in data-raw seen in the screenshot

Definition of Done

• Investigate source of the error and report back in this issue
• Propose fix to the function and/or example datasets used.
• Implement fixes and Profit 💰

@pharmaverse/admiral @pharmaverse/admiral_comm anyone familiar with these query datasets and want to take a peek please?