v2.5.0

MIMIC Code v2.5.0

Major changes

• Linting/formatting SQL files with sqlfluff
• Converting BigQuery syntax SQL to postgres/duckdb using sqlglot
• Improvements in concept queries (thanks everyone for contributing!)

What's Changed

• Add linting of SQL files using sqlfluff by @alistairewj in #1480
• Postgres shell script update by @alistairewj in #1482
• Fixed an error: Line 90, an L is missing, by @lewis738 in #1503
• fix NULL typo at mysql buildmimic-iv load.sql by @asha-ndf in #1502
• Fix gh db build by @alistairewj in #1504
• fix issue 1279 by @yongfanbeta in #1497
• Improvements for duckdb by @alistairewj in #1489
• fix gh actions by @alistairewj in #1506
• Fix norepinephrine in PSQL, tidy vasoactive code by @alistairewj in #1505
• Update load.sql by @trostalski in #1492
• Create view for code_status in MIMIC-IV by @ajb5d in #1291
• fix typo in extraction of diabetes_without_cc by @alistairewj in #1508
• change dir as import_duckdb relies on relative dirs by @alistairewj in #1509
• Streamlining and updating Postgres building process for mimic-iv, mimic-iv-notes, mimic-iv-ed by @stefanhgm in #1537
• fix: MIMIC Note README.md by @aegis301 in #1592
• remove stale/broken docker scripts, see #684 by @alistairewj in #1635
• fixing wrong mimic-iv folder name by @fvillena in #1639
• Fix constraint.sql for mimic-iv-ed PostgreSQL by @SimonUzL in #1659
• Add the 'load_7z.sql' script to enable the loading of 'ed' module dat… by @notwarn in #1656
• Changed column widths to import data without truncating by @KenjiOhtsuka in #1608
• Update code_status.sql by @SichengH in #1676
• fix sapsii and oasis score based on issue 1568 by @yongfanbeta in #1587
• nsaid & acei medication by @Juan-L-Dominguez in #1680
• Add duckdb build/concepts and use SQLGlot to convert BigQuery SQL into other dialects by @alistairewj in #1689
• Add procedures mappings for MIMIC-IV v2.0 - SSSOM format by @a-chahin in #1419
• Fix GitHub CI by using a Python container by @alistairewj in #1783
• Increase admissions language length for postgres schema by @MB-Finski in #1776
• SQLite python improvements by @alistairewj in #1784
• Sqlglot fixes by @alistairewj in #1786
• add validate.sql for mimic-iv-note by @Jin-Zhang-Yaoguang in #1687
• Fix SQLite build using all CSV files by @alistairewj in #1788
• ARBs SQL by @Juan-L-Dominguez in #1690
• Add ARB by @alistairewj in #1789
• fix #1354 by @rustamzh in #1785
• Fix bug: Columns dislocation in the 'emar' table. by @Scott1743 in #1779
• fix: Readme mimic-iv postgres build and concepts links by @chamathpali in #1685

New Contributors

• @lewis738 made their first contribution in #1503
• @asha-ndf made their first contribution in #1502
• @trostalski made their first contribution in #1492
• @fvillena made their first contribution in #1639
• @SimonUzL made their first contribution in #1659
• @notwarn made their first contribution in #1656
• @KenjiOhtsuka made their first contribution in #1608
• @SichengH made their first contribution in #1676
• @Juan-L-Dominguez made their first contribution in #1680
• @MB-Finski made their first contribution in #1776
• @Jin-Zhang-Yaoguang made their first contribution in #1687
• @rustamzh made their first contribution in #1785
• @Scott1743 made their first contribution in #1779
• @chamathpali made their first contribution in #1685

Full Changelog: v2.4.0...v2.5.0